Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi,Looking for different ideas to create scheduling functionality in quickbase.Need to add calendar or something similar to log meetings so that notifications can be sent out to the specific users per calendar updates.------------------------------Mrunali Kadam------------------------------
Hello, I'm attempting to migrate my automation over to Pipeline, but I've received errors and am not really sure how to resolve the error. ------------------------------
I am trying to correct one of the design issues with an app I inherited. The original design did not contain a contacts table. As a result I have several fields in tables that are storing name, email and phone data. I created a Contacts table and a relationship to the Master table with the Contacts as the parent. But I cannot see how to use the data in the Contacts table to populate multiple sets of contact related fields. I look forward to your suggestions.------------------------------Paul Peterson------------------------------
Here is my formula, which returns the value of the maximum. But I'd like the field name of the maximum:If([Sample Size]>1,ToText(Max([Bird Damage],[Bruise],[Corking],[Decay],[Discoloration],[Growth Crack],[Hail Damage],[Insect Damage],[Leaf/Limb Rub],[Mechanical],[Mixed Sizing?],[Mold],[Open Suture],[Potato Skin],[Russeting],[Scar],[Shriveled],[Silvering],[Slip Skin],[Soft],[Soft Tip],[Speckling],[Split Pit],[Staining],[Stem Pull],[Sun Burn],[Undersize],[Worm],[Worm Hole],[Glass/Metal/Rocks/etc.])),null)------------------------------Davis Ward------------------------------
Hello,I'm trying to get a url button from a report to edit a record and return to the original launch point. This is my code. The edit works, but I cant get the screen to refresh. var text ReturnToOriginalLaunchPoint = "https://xxx.quickbase.com/db/xxx?a=q&qid=74";URLRoot() & "db/"& Dbid() & "?act=API_EditRecord&apptoken=xxxxx&rid=" & [Record ID#] & "&_fid_6=" & URLEncode(1)& "&NextURL=" & URLEncode($ReturnToOriginalLaunchPoint)I get an error message.. This XML file does not appear to have any style information associated with it. The document tree is shown below. <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>660</rid> <num_fields_changed>0</num_fields_changed> <update_id>1655872xxxx</update_id> </qdbapi> ------------------------------Jamil Idun-Ogde------------------------------
------------------------------Daniel Johnson------------------------------
I want figures in words as per Indian Currency.I have used the below formula. The problem with the formula is it is reading 400000 as 'Four lakh Thousand Rupees' whereas it should be 'Four Lakh Rupees(4,00,000)' and for 120000 it is reading correctly as 'One Lakh Twenty Thousand Rupees'. Also if the figure is 84.65 then ideally it should be "Eighty Rupees and Sixty Five Paise' and not 'Eighty Rupees and Sixty-Five cents'.Formula -var text numt = ToText(Floor([Total Material Cost (INR)]));var text cents = If(Contains(ToText([Total Material Cost (INR)]), "."), Left(Right(ToText([Total Material Cost (INR)]) & "00", "."), 2),"");var text teensnum = List(" ",Case(Floor(ToNumber(Right($numt,2))/10),1, "Ten", 2, "Twenty", 3, "Thirty", 4, "Forty", 5, "Fifty", 6, "Sixty", 7, "Seventy", 8, "Eighty", 9, "Ninety", 0, ""),Case(ToNumber(Right($numt,1)),1, "One", 2, "Two", 3, "Three", 4, "Four", 5, "Five", 6, "Six", 7, "Seven", 8, "Eight", 9, "Nine", 0, ""));var text teens =If($teensnum<>""
I have a series of If conditions I want to figure out but am getting a boolean error at the end of the statement.If([FC Shake Type2]="Staggered Shake", [Actual Shake Siding], //Condition 1 if([FC Shake Type2]="Straight Shake",0, //Condition 2 if([City Set Shake Type]="Staggered Shake",[Actual Shake Siding], //Condition 3 if([Bid Set Shake Type]="Staggered Shake",[Actual Shake Siding],0),0)),0)Screenshot of formulaError Message:Just wondering where I went wrong in the formula, it looks right to me but there's the error saying I'm wrong.------------------------------Paul Elliott------------------------------
Hello,I am working on an app where I set up a form where users provide different data. One field that I have is an email field called Notification Recipients. In this field users can provide multiple emails split with semicolon. For example: 'A.M@domain.com;A.M2@domain2.com;A.MM@domain.com'. I'd like the form to be accepting only the emails that have '@domain.com' and for others to provide an error message and not allow the form to be submitted.I tried to set up a formula field for that, but that failed for such list.I will be grateful for any hints or suggestions on how to solve my problem.------------------------------Arleta Maæka³a------------------------------
I'm fairly new as a developer in QB, but I have long experience from other tools. How do I handle many-to-many relations between tables in a more general way? In QB you can sometimes use a entity table in between like in the attached diagram, but how to handle relations from one table to the same table? One example would be to have a relation from a (sub)project to a main project and still only have one Project table entity. Now to something I don't know. Is there a functionality available in QB for a field that acts like a "lookup" field. It would make it possible select from a list from a table or something else and the selected value would be stored in the field. Can I use a Formula-text field and some code to calculate a reference from table Project to itself or to another table? And make the field and the UI function like a lookup? /André ------------------------------Andre Ekespong------------------------------
Hi,I was going through the quickbase university courses and came across this use case of using pipelines' Quickbase Records Updated feature to log changes to a table. Building Powerful Pipelines Using included FeaturesI have a similar use case, but I have nearly 40 fields in the table and I only want the log a single changed field in the log table. In coding, I would do something like: for field in table_fields: if field.prev.value != field.current.value: create_logs_record(field.name, field.prev.value, field.current.value, ...) Is there a way I can efficiently do this in pipelines using jinja or some other method?Currently, I have a trigger on update and then a long series of `if changed, create record else ...` which is tedious to create and would be difficult to modify.------------------------------Bradley------------------------------
Good Day,I have an Assets table, each asset requires preventative maintenance on a schedule of X days (30, 60, 90 days, etc.) after last completed. This creates the PM Due Date.In the same App, I have a Work Order table that assigns the task to personnel based on the Asset selected. Is it possible to automate the creation of a new record (work order) when the due date of the PM (Asset table) is approaching (7 days prior).Any thoughts are appreciated.Landon------------------------------Landon Smallwood------------------------------
I saw a list of input fields format somewhere..for example:{{a.$prev.xxxx}}I can't seem to find it now. Please advisethank you------------------------------BuildPro------------------------------
Hi Team,We've some checkboxes as required on the form. If user doesn't select any checkbox then it shows 1st checkbox field name in the error message. Is there any way we can update the error message?------------------------------Mrunali Kadam------------------------------
I am trying to calculate the number of months between a start and end date. Start and End may not be in the same year.For Example:Start Date is June 1, 2021 and end date is October 31, 2023. I would like to include the months of both Start and End dates. Answer should be 29 months.What might my Numeric Formula look like?------------------------------George Bramhall------------------------------
I am working through the Quickbase University "Building Powerful Pipelines Using included Features" course and am stuck on the "Call another pipeline" exercise using 3 pipelines to add courses when an employee is added or updated. Pipeline 1 & 3 are functioning, but pipeline 2 as built per instruction does not recognize that an employee record has been updated where the isManager checkbox field is updated to Yes.I am wondering if it has anything to do with the syntax. Here is the instruction:Here it is in my pipeline:When I update an employee record and make the checkbox for isManager = yes, the pipeline does not recognize the record update event and does not run.Suggestions?------------------------------Adam Keever------------------------------
I have a logical test that fails when comparing blank fields. The test checks if a field in Table A is equal to a field in Table B. Table A is an is created within quickbase and Table B was manually imported from excel.The IF/THEN statement works fine until it encounters two fields that are blank. Looking through the activity log, pipelines reads the value of the blank field in Table A as "None" and the value in Table B (excel import) as "". I have gone through the fields in my tables and verified that they are all empty.Has anyone else experienced anything like this? Does anyone have any idea why one empty field is read by pipelines as "" and another as "None"?#Pipelines------------------------------Andrew Hansen------------------------------
While searching for data through the API I realized that the EX query is case sensitive.In my specific table, this returns nothing: "{'6'.EX.'JOHN DAVIS LLC'}" while this returns a record: "{'6'.EX.'John Davis Llc'}" Is there a way make a search non-case sensitive?Thanks,// Francesco------------------------------Francesco Gallarotti------------------------------
Currently I am setting a time line report for a project to create a Gantt chart.How I have it setup is a projects will have multiple PO's to different vendors. On each PO I can create multiple Gantt entries. From the project I hit my formula url button to make a temporary report of all Gantt entries.URLRoot() & "db/" & "table ID" & "?a=q" & "&qid=5" & "&query=" & "{'15'.EX.'"& ToText([Project Number]) & "'}"When I change "&qid=5" to 1 to use the list all report the filter I have in my formula works correctly. But when it is set to "5" which is a time line report, the filtering does not work.------------------------------Russell Beaubien------------------------------
I want to color code based on due date.Green = On Track (11 + days in future)Yellow = Due Date is within 10 daysRed = Overdue is after the due date.I was able to get my formula for green and red to work but my yellow is not working. If it is supposed to be yellow, it is actually turning green instead.Any help would be greatly appreciated,Thanks,Sandy------------------------------Sandralee Oster------------------------------
Help! While fairly new to "fun" with formulas, I am trying to calculate a simple duration. I've got field "Date Advisor Received" and "Date Completed" Both are Date Type fields. I've added another field "Days Open/Advisor Actively worked" Formula NumericI'd like the days to calculate when the Date Completed Field is not populated.My formula:IF([Status]="Complete", ToDate([[Date Client Advisor Received]]) - ToDate([[Date Completed]]) , Today() - ToDate([[Date Client Advisor Received]])The 1st Date Client Advisor Received comes back with error Field not identified. HELP please!------------------------------Jamie Strauss------------------------------
SetupI have an application with two tables (really more than two but the issue is surrounding two specific tables), and each of those tables contains a multi-select field with the same options. I designed a pipeline that would create a record in table b and copy the multi-select field selections from table a. The issue is that one of the options in the multi-select field is "Offers, Products, and Catalog". As you may be aware, when passing options from a multi-select field through automation it comma delimits the selections. So, in this case the automation is treating it like 3 separate options versus a singular option, thereby stopping/failing the automation. Should I simply put quotes around the choice so it treats it like a string value, put dashes between the options, bracket the option, etc.? What's the proper handling of a situation like that?------------------------------MICHAEL SARGENT------------------------------
Is there a way to use the GetFieldValues query, but have it only return a string of unique values? Eliminating duplicates?------------------------------Mike Tamoush------------------------------
Thank you all for considering my post. I am trying to create a checkbox formula that mirrors this set of report filters:I am having a Dickens of a time to get the same results as the report displays. Create a new report where [Formula Checkbox] = true and delivers the same results as these filters. I need to pass the Formula check box back to other table(s). Many thanks.
Is there a chance there will be a Samsara Channel in Pipelines?------------------------------ROBERT STEVENS------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.