Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm trying to make a numeric formula field that will only calculate a Total Invoice if the Override Points are blank (or zero) AND the Approved checkbox is checked (true).This part worksIf([Project Points Override]=0,[Project Points]*[Contract Coach - Current Rate],[Project Points Override]*[Contract Coach - Current Rate])When I try to add the checkbox=true it does not work. I'm sure I'm missing a syntax somewhere hereIf([Project Points Override]=0 & [Approved],true],[Project Points]*[Contract Coach - Current Rate],[Project Points Override]*[Contract Coach - Current Rate])It says the "=" can't be used on a type number. Any suggestions?------------------------------Dawn Rene------------------------------
I've a simple JSON file, I'm able to use JSON handler in pipeline but it only 1 creates 1 record which clubs all values it has iterated . Is it possible instead to create multiple records with 1 value each VALUE : {{b.raw_record["Sub"]}} JSON SCHEMA IN PIPELINE { "File": [ "https://drive.google.com/file/d/198aaoChWTow6sI6UR6tjacVehkn42obz/view?usp=drivesdk" ] } JSON { "Sub": [ { "File": [ "https://drive.google.com/file/d/1qcp01CTNJTp1h49sHKvd5tNaWq7CZJ9a/view?usp=drivesdk" ] }, { "File": [ "https://drive.google.com/file/d/1CnpmMC-Em4cFr-4_sUCHCFVPqvdwKMcP/view?usp=drivesdk" ] } ], "sl": "Bhaiya" } ------------------------------Prashant Maheshwari------------------------------
[Start Date]-[End Date}Start Date is 8/15End Date is 8/18Need to return 3 days as the quantity, but this returns 2 daysAlso, I then want the 3 days to convert to 24 hours (3 work days)Please advise.thank you------------------------------BuildPro------------------------------
Is there a way to convert text into numerical values? What I am trying to do is have several fields where the choices can either be yes, no or NA. I want each of these to assign a numerical value.for example:field one: yes = 30, n = 0, na = 30field two: yes = 30, n = 0, na = 30field three: yes = 40, n = 0, na = 40Then I want a field at the end which gives the percentage ... so if field 1 was yes, field 2 was no and field 3 was yes the score would be 70%. Attached a mockup screenshot of what I mean. Thanks. ------------------------------William------------------------------
Hi,I am creating a pipeline using the Outlook channel to send an email. I have a duration field {{a.days}} in the body of the email that is not coming through correctly. A value of 2 days comes through as 172800000. Any ideas on how to have it display correctly?Thanks,Deb------------------------------Deb Lanser------------------------------
Is it possible to lock a form from being edited, based on a dynamic rule? Or do I have to individually select every field to be read only?------------------------------Michael Tamoush------------------------------
Hello,My Child Table is not populating the look up fields from the parent table even though my tables are connected, and I have added the look up fields to the form.I have the proxy reference added to the child table as well.thank you,Reza------------------------------Reza Khosrowabadi------------------------------
Hello, I've followed the various tutorials for creating pipelines, but none seem to fit my needed scenario. I need a record to move to another table if a field contains a certain selection, and then after that record is moved to the new table I need it to delete from the previously located table. And - if someone needed to go back and change the record field to move it back to the previous table and delete it again from that table. Scenario 1) Status is changed > move to the closed records table> Delete the record from the open records tableScenario 2) Status is changed > move the record from the closed records table to the open records table > delete the record from the closed records.------------------------------Lorrie B------------------------------
Hello Everyone,I am trying to create a summary report that shows a list of clients that are not repeated clients. The date range is from 8/1/22 - 7/31/23. Starting in August all clients are new, however when September happens I need to see only new clients. I was thinking about creating a formula in the summary report but have not idea on how to isolate new clients or to check the previous month to see if the client has already come in. Does anyone have any ideas on how I can solve this or any suggestions? I have clients that have been listed from previous years but this report is to focus on the next 12 months.------------------------------Alex Bartholomew------------------------------
Hello everyone,I have a formula that brings in data from another table and it could have multiple results. When I do there is an extra space at the end before the ";". I have been trying to figure out how to get rid of the space but no luck. I either remove all spaces or I only get part of my results.Formula: ToText(GetFieldValues(GetRecords("{8.EX.'"&[Project]&"'}", [_DBID_X]), 286))Result with extra space before the ;1 % ; 1 % ; 1 % or 5 mg ; 10 mgTrying to get1 %; 1 %; 1 % or 5 mg; 10 mgAny help is appreciated. Thanks------------------------------Jennifer Silberstein------------------------------
Help please. How do i put this into a formula:If a duration field is > 3 days and a date field is empty then color the row blue.Any help would be appreciated!------------------------------Mike S------------------------------
I'm new to writing formula queries and keep running into type mismatches. I'm figuring bonuses for our technicians, and have the bonus rate stored on another table.var text myquery= "{8.EX.'"&[User to text]&"'}";Getfieldvalues(getrecord($myquery,[_DBID_TECH_Info]),7)The formula above says it's expecting a number but found text. Do I need a different function to look up a text field?------------------------------Anne Martin------------------------------
I have a pipeline that is pulling in external data and storing it in a holding table until a second pipeline moves them into another table after the data is validated. Some of the fields involved are file attachments. I am having difficulties moving the file attachments. Can someone please provide a general overview of the process needed to move the fila attachments?------------------------------Paul Peterson------------------------------
As of this morning:When I open a table report, the column widths are automatically expanding? I need my column widths to stay as I set them (narrow)..we do screen shots and don't want wide columns. On a Mac desktop, using Chrome...Thank you------------------------------BuildPro------------------------------
Hello! I have project coordinators that oversee projects and project communication (Users)Whenever an automated email notification gets submitted to outsourced emails in the system, I want to have the Users email attached as one of 2 options:1) The sender2) in-line of the email like how I can select an email address field and place it into the email.* For option 2 I was looking to see how I can create a lookup field for the users email they use to access the system, but I couldn't find it.Any other solutions besides what I've mentioned I'm open to hear, I simply need to make sure that the individuals receiving these emails know who to reach out to instead of the generic notify@quickbase email they receive. Thank you so much :)------------------------------Anthony Wong------------------------------
For you pipeline experts out there, can anyone please tell me why I get this error message after trying to drag a Billing Address field from a created record onto a create record field?This pipeline was originally created using just a city and zip text field (not using the Billing Address fields) and when I modified the app by utilizing the Billing Address field and tried to update my pipeline with values from this field, it started throwing this error message.Do I need to recreate the pipeline completely?------------------------------Doug Crandall------------------------------
Is there a way I can use a formula query to, using a set of criteria, find the record with a previous date? ie - return the maximum date that is prior to the current date.Example:My query narrows down to records with these due dates:1-2-224-5-227-7-2210-20-22The earliest date returns nothingRecord with 4-5-22 returns 1-2-22Record with 7-7-22 returns 4-5-22etc...There will be no ties so that is not a worry------------------------------Mike Tamoush------------------------------
Is there a way to calculate the mileage between two different address fields?------------------------------Annalise Sansouci------------------------------
Using magic buttons to upload multiple files and it is working great. I have one app that I would like to do the same but the files have a type associated with it. For example, I need to upload 10 files and chose the file type as "drawing" or "email". Any suggestions on how I do that?------------------------------Sarah Burres------------------------------
I want to have a place to store our photos in Google Drive and have them present on a page similar to the photo I have attached here. Any ideas on how to achieve this?------------------------------Jennifer Meyer------------------------------
Hello,I am having an issue where I am unable to select a Text -Multi-line field in my pipeline under the "Select fields to specify values". When I go to search for it, it is simply not there. I've removed and added it from the initial "Fields for subsequent steps" multiple times. I have even created a duplicate of the field named the same with a 2 at the end and it appears. Unfortunately this is a crucial field that I need. Is this potentially a bug? Screenshot attached.The field I am looking for is Requestee Notes. The duplicate field of it Requestee Notes2 does appear though.------------------------------Shane Miller------------------------------
I am needing to scan a pallet full of barcodes into an inventory system .. does anyone else have experience with doing this using the mobile app? So far, I can only figure out a 3-tap minimum solution of tapping into the field, tapping the barcode button, then tapping save / next. With 300 barcodes to scan, per pallet .. I'm thinking I might just be better off buying a barcode scanner.------------------------------Malcolm McDonald------------------------------
I know I'm missing something that's probably incredibly obvious, but here goes. I am trying to combine static and dynamic text in a pipeline field, a field name and some text.I didn't expect my first guess to work, {{a.field_name}}_Text, but the other things I tried didn't work either. I'm sure one of you has the answer.Thank you in advance.------------------------------Paul Peterson------------------------------
I am writing custom data rules and would like to have a rule that when a specific Multi-Select Text field [Items Awarded] is blank/null the record cannot be saved.I've tried using each of the following, and each returned an error[Items Awarded] = "" -- The operator '=' can't be applied on types textlist, textToText([Items Awarded]) = "" -- Expecting text but found bool[Items Awarded] = Null -- Expecting text but found boolISNULL([Items Awarded]) -- Expecting number/date/datetime/TimeOfDay/duration/workdate/user/userlist but found textlistHow do I use a formula to check for blank/null Multi-Select Text fields?------------------------------Amanda ThomasBusiness Systems AnalystMorse Steel ReinforcingBellingham WA360-756-6208------------------------------
Hello,I have a request from a team looking to take a notes field and have it only display the most recent update. They want to be able to still edit this field within the table and not go into the form or another table to make changes. Truly a one stop shop for processes.The field is currently logging edits. I thought this formula would work within the report:var text LogField = [Notes];If(Trim($logField)<>"", "[" & Left(NotLeft($LogField,"["),"["))I am having no luck with it filtering down to only the most recent. Is there any formula that could do this and still allow for them to edit the field?------------------------------Sarah Driscoll------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.