Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello, I have a multi-select list that has 5 items on it. All 5 items need to be checked off for quality purposes. I created a separate formula field to check this condition, but I can't figure out the logic to get the correct result.My multi-select field is called "[The SOW was reviewed and SOW has the following items:]".Here is the Boolean code that I put into the separate formula field. Regardless of what is checked off, the result is always the false choice, "SOW is not complete":If(ToText([The SOW was reviewed and SOW has the following items:]) = ToText("Anticipated LOE by Contract Labor Cat (Qty & Hrs) by JID") andToText([The SOW was reviewed and SOW has the following items:]) = ToText("Place of Performance") andToText([The SOW was reviewed and SOW has the following items:]) = ToText("PoP and Planning Start Date (if before the POP start date)") andToText([The SOW was reviewed and SOW has the following items:]) = ToText("Detailed Work Scope") andToText([
All:I know this is simple but its my first time to get this to work. Please adviseI have a query formula field where I call some data. I want that data to display in a neat table on the record. Here is a screen shot of my record with the two rich text fields. The first being the formula query, the second, my sloppy attempt at an html table to put the data. Any help is appreciated. Here is the code behind that Rental Calculation Table Field:"<table>" &"<tr><th>recordid</th><th>Client Portion</th><th>NLSM Portion</th><th>Propert Rent</th><th>NLSM Utility</th><th>Last Modified By</th><th> Date Modified</th></tr>"&[Client Rental Calculation Query Field]& "</table>" ------------------------------Melissa Freel------------------------------
Hello all,Question 1: Is it possible to show a total of the "Estimated Revenue" and "EST COGS" after each month instead of a grand total at the bottom? Question 2: Is it possible to have the "Closure Percentage" field editable in a summary report? Need to take summary data, apply a "closure percentage" and calculate the "Revised Revenue" and "Revised COGS"? ie. closure percentage is 90% for Feb 2022 Confirmed- rev: $326,649.35 & COGS: $148,847.79. So "Revised Revenue" field would be $293,984.42 and "Revised COGS" field would be $133,963.01. As a work around, I've added columns to a summary report so we can export to a csv file however what is the best way to create this functionality within the app? ------------------------------Vero Fabiana------------------------------
I'm using Kirk's method to upload multiple documents at once and ran into a little problem. The form in which I'm uploading the documents from has a couple of grid edit reports on it for ease of entering data, however everything entered in these grid edit reports are lost if the User then scrolls to upload documents before saving. When using Kirk's method, the record is not saved before the UI opens to upload documents and everything entered in the grid edit reports are then lost. My goal here is to add code in this button to save the record before opening. URLRoot() & "db/"&Dbid() & "?a=dbpage&pagename=MultiDocUpload.html&refFid=6&rid=" & [Record ID#]& "&applicationtoken=cfnbe4ydp5cqspbksxi3nd949xxx"& "&fileattachment=14"& "&categoryFid=12"& "&attachmenttableurl="& URLRoot() &"db/" & [_DBID_DOCUMENTS]Any help would be greatly appreciated!------------------------------Todd ---------------------------
Hello - I was hoping for some direction on how best to create a field for deliverable planned start and deliverable planned finish that would calculate based off the minimum start of associated tasks and maximum finish of associated tasks. I'd like my result to look like the below: Project Name Deliverable Name Task Name Planned Start Duration Planned Finish Deliverable Planned Start Deliverable Planned Finish Project 1 Deliverable 1 Task A 04/26/22 3 04/28/22 04/26/22 (?) 05/04/22 (?) Project 1 Deliverable 1 Task B 04/29/22 5 05/03/22 04/26/22 (?) 05/04/22 (?) Project 1 Deliverable 1 Task C 05/04/22 1 05/04/22 04/26/22 (?) 05/04/22 (?) I cannot seem to create a query that would list out 4/26/22 as the deliverable start and 5/4/22 as the deliverable finish.This is in a task table called DBID_NEW_TASKS Project Name = field 49Deliverable Name = field 7Planned Start = field 20Planned Finish = field 22Is Start Milestone = field 23Is Finish Milestone = field 64W
Is it possible to download all of the records in a Summary Report to one csv? We have a Summary Report grouped by 8 different rows and 5 columns, but I can't find a way to download all of these records as one CSV. I can click on each row heading, which opens a drill down report, and then download all the records in that row (group). But I don't want to have to do this 8 times if there's an easier way?Thanks!------------------------------Amber Gartner------------------------------
Hi All,Are there other MFA option aside from email I use with Quickbase? I would like to do away with using the same email as a recipient for the 2FA code as this is the same email I use when logging into quickbase. I'd appreciate any help you can provide.Thank you!Dennis------------------------------Dennis Salvador------------------------------
I am working on creating a Summary Field from Formula - Rich Text and keep getting the error "The operator "<>" can't be applied on types textlist, text". Formula = List("\n", If([Field 1]<>"", "Summary Text 1:" & [Field 1])The below formula is nearly what I want, but I don't want to summarize the field if the field is blank and the below formula still adds the "Summary Text 1:" if the field is blank.Formula = ToText("Summary Text 1:" & [Field 1])Thanks!------------------------------JASON VOSS------------------------------
Hello, I am looking for a jinga expression/syntax which could help me validate the sum(Field-1) > NN value in a step using if condition. Below is the pipeline steps:Table-B structureRecord ID#, country, Qty issued1, UK, 20.5,2, UK, 303, UK, 30.8PipelineStep-A When the record is created in table-AStep-B Search records in Table-B where b.country = "UK" If sum(qty) >= 100 Step-C - Create record in Table-C Else Step-D - Create record in Table-DI want the jinga expression to be added in step-B post search is returned to check the sum(qty) and compare if it exceed or equals 100 ------------------------------MC ------------------------------
I have an application that has a work group intake table [Parent]. From that workflow intake, it can be assigned to multiple work groups [Child]. And then can be assigned to multiple individuals [Child of Child]. I have created multiple summary fields from the work group records to the work group intake table. I now want to aggregate the multiple summary fields into another field. I know I can use the "ToText" function to summarize the fields, but it then leaves the semi colon delimited. That's not visually appealing. I want something like: Summary field 1 - [Summary field 1] Summary field 2 - [Summary field 2] Etc. I can't figure out how to code it so it appears nice like that. Any help is welcome.------------------------------MICHAEL SARGENT------------------------------
I have a comments field that is long enough to really mess up the table view, so I want it to only display the first 20 words unless you click into it. How can I do that? I tried to do use this formula to shorten the view of my "appt. comments" text field in my table. Left([Appt. Comments],20) However, I received this message "Formula errorA formula may not contain a reference to itself directly or indirectly through another formula." Any idea on how to do this?------------------------------Meagan McOlin------------------------------
When using summary reports, is there a limit to the number of 'report formulas' one can use? I have created 3 formulas, and now the 'add another formula' button is disabled. Is the max 3?------------------------------J G1987------------------------------
I'm trying to use a different color based on whether a checkbox is checked.case([Standards],true,"#5E9DFF",([LOA]),true,"#F54400") It gives me an "Expected text but got bool" error. I don't need both to be true, just if [Standards] is checked then one color or if [LOA] is checked then another color.Thoughts?I can get one color to work, but not able to add the other.------------------------------Tony Miller------------------------------
Has anyone utilised an e-signature requirement in one of their forms? And if so, how did you do it?------------------------------Chris Swirtz------------------------------
Hi,I am working on a workflow solution and am struggling to solve a problem. Hoping someone in the community who has a bit more experience with pipelines may have a (relatively) straightforward solution I'm not thinking of.Here is what I'm looking to accomplish:Two tables involved:1. Parent table = A2. Child table = BEach month, users will have a grid edit report where they can see their B records from the prior month. My idea is they will check the renew checkbox field on this report for B records they want to renew for the current month and save the report. The past month's records will need to stay associated to their A record, so copies of the renewed B records will need to be created and associated with a new A record.The question I have is, how do I get the trigger to recreate (copy) the B records for each trigger, but only create a single A record to tie them to. Example, a user wants to renew 6 B records, so I would need 6 new B records created, but only 1 A record create
Hello! We want to create a Formula-Checkbox field that is true when a certain trigger occurs, when it "switches" we want it to stay switched and never change back. Is that possible with QB?For example if there are 3 stages of a record like stage 1, stage 2, stage 3...when it switches to stage 2, we want it to stay stage 2 even if it goes back to stage 1 or to stage 3. Basically, once it hits that trigger, the field locks. Thanks so much,------------------------------Gelo------------------------------
What is the permission I can use to let people create their dashboard?
HiI have two related pipelines. One should trigger based on the actions of the other, but it's not. Pipeline 1: When a new record is created in Table "Notes", a date field is updated in the related Table "Account." Pipeline 2: When data is updated in Table "Activity," a new record is created in Table "Notes"If I create a new "Notes" record, it will run Pipeline 1 just fine. However, if a new "Notes" record is created through Pipeline 2, then the Pipeline 1 will not run, and the related date is not updated. Why not? If a Pipeline creates a record, does that not count as a record created to trigger the other Pipeline? Do I need to build in the actions of pipeline 1 into my pipeline 2?I confess I'm a bit late to the Pipeline party and just slowly trying to migrate automations. These migrated fine, the one isn't working all of the time it should. I have others with YAML errors, but that's a question I'll deal with another day.Thanks
Hello I am trying to get a url formula button, From Magic Buttons, to work to where it creates a child record and opens it in edit mode. I have created a Code Page and URL Formula button field on the desired table. For some reason it keeps coming up with a error every time I try it. Can yall help me figure out whats wrong?Here is the code for the Code Page<!DOCTYPE HTML><html><body><script>const urlParams = new URLSearchParams(window.location.search);const rid = urlParams.get('rid');const apptoken = urlParams.get('apptoken');const targetdbid = urlParams.get('targetdbid');const referencefield = urlParams.get('referencefield');const Patient Full Name = urlParams.get('Patient Full Name');const Patient Email = urlParams.get('Patient Email');const Patient DOB = urlParams.get('Patient DOB');const Patient Phone = urlParams.get('Patient Phone');const Physician Full Name = urlParams.get('Physician Full Name');const Physician Email = urlParams.get('Physician Email');const
Hi!I am attempting to Fetch JSON> Search Records and if no records found> Create a New Record.When attempting to input the advanced query to search records, what value would I input for the formula if I would like the search to be based off the incoming individuals' address and email which of course will change every time? Heres what I have so far, again, not sure how to write the value if it will be different for each person.<query>{'5'.EX.'value'}AND{'8'.SW'value'}</query>------------------------------Magaly Reyes------------------------------
Yes, I leveraged my dog to lure readers to my post, but she has not failed me yet when it comes to standing out and networking. While we would love to share the excitement of Empower with you all in person, we have once again adapted and gone Virtual. I hope to see you all there! While not all of us have a photogenic dog to stand out in the crowd, here are some tips to get the most out of Empower and grow your Quickbase network! 1. Are you registered? Let’s start with the easiest, registration! If you plan to attend Empower 2022, and I hope you do, please register here, if you have not yet done so. 2. Check out your Profile. Is your attendee Profile up to date? Is your Profile picture one of you from the last year or so? Adding a bio to your profile will encourage other attendees to connect with you and add to your presence at a virtual event. Check your LinkedIn Profile. Does it reflect your current title and job responsibilities? Are you Quic
Can someone help me with an advanced query for my pipeline.The formula should filter for the following:Date field id 31 is after Date field id 70 and Date field id 31 is before Date field id 71 and Date field id 20 equals Date field id 39.I can't find any good examples of how to write this filter formula for my pipeline.Thanks------------------------------George Bramhall------------------------------
Essentially looking for a way to basically start over on a form while adding a record without having to cancel the add and re-click add record.For instance, if a user had entered several fields of data on a long form and realised they were reading the info from the wrong source. I would like for the user to be able to ideally click a button and clear the data out so they can start fresh.------------------------------Chris Swirtz------------------------------
Please make this work for me.List(" | ",(ToText([Job - Neighborhood/Subdivision])),[Job - Lot #]);IF([Job - Neighborhood/Subdivision]="Jameson Place","<b><font color=#948D68>"& $MyConcatenatedFields & "</font color></b>", $MyConcatenatedFields,[Job - Neighborhood/Subdivision]="540W","<b><font color=#FFCC66>"& $MyConcatenatedFields & "</font color></b>", $MyConcatenatedFields,)------------------------------BuildPro------------------------------
What are the most common Quickbase functions that can affect performance? The table below describes some of the most common actions Quickbase performs and how they affect system performance. If you are trying to optimize performance in Quickbase, it's helpful to understand these actions so that you can make any necessary adjustments.Action: qName: QueryDescription: Query a table using a shared, personal, or temporary reportRecommendations: - Be sure to order filter criteria in reports carefully. Quickbase processes filter criteria sequentially. Your reports should eliminate the most records with the first filters.- Try to use native data fields (from the table you are in) rather than derived fields like summary or formula fields. Derived fields must do additional queries, permission checks, and calculations before they can be evaluated against your query.- Wherever you can, use exact matches when building your filter criteria. Using is equal to as your matching operator will be faster
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.