Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
“How long did this project sit in each status?” comes up a lot, and the usual first idea is a formula that compares one log record’s date to the next one. A record’s formula can’t see “the next record” on its own, and formula queries get slow on a busy log table.What works well is linking each status record to the one before it, then closing the old record when a new one shows up.On the relationship from the Status Log table to Projects, add a summary field: Maximum of Record ID#, called Latest Log ID. Record IDs only go up, so this is always the newest log record. Look it up back into the log table.On the log table, add a Numeric field called Previous Log ID and put both fields on the add form. Add a form rule: when the record is being added and the Latest Log ID lookup is not blank, change Previous Log ID to the value in that lookup. While the form is open the lookup still shows the old latest record, so that’s the ID that gets saved. The first status record for a project just stays
If a pipeline creates records, sooner or later it will run twice for the same thing. An edit re-fires the trigger, someone ticks a checkbox again, a step gets rerun. With Create Record, every extra run adds another copy.The fix is to give each record a key that says what it is, and write with upsert instead of create.[Inspection Record ID#] & "-" & [Checklist Item Record ID#]Add a Text field for that key on the table the pipeline writes to and check Unique in its properties. Now Quickbase won’t accept a second record with the same key, even if something is misconfigured.Then replace Create Record with the Bulk Record Sets steps: Prepare Bulk Record Upsert with the key field as the merge field, Add a Bulk Upsert Row inside your loop, and Commit Upsert after it. If the key already exists the row is updated, otherwise it’s created.One thing to watch: an upsert overwrites every field you map. If people edit those records by hand afterward, only map the fields the pipeline owns.It’s
A lot of apps have records that follow earlier ones: renewals, revised quotes, reissued tickets, this month’s inspection after last month’s. It’s tempting to connect them by matching a name, a ticket number or the latest date, usually with a pipeline or a formula query. That works until someone fixes a typo or two records share a date, and then it quietly points at the wrong record.Store the earlier record’s Record ID# instead, and relate the table to itself.Add a Numeric field like Previous Record ID. Create a table-to-table relationship with the same table as parent and child, and choose that field as the reference field. Now each record knows exactly which one it follows, and lookups can show the previous record’s values right on the form.On the other side, a count summary field tells the old record whether anything replaced it:If([# of Newer Records] > 0, "Replaced", "Current")Nothing has to go back and edit the old record, and if the new one is deleted, the old one goes back to
I'm trying to open an existing chart report with a dynamic filter passed through a URL. Using ‘qid=117&query=...’ opens the chart but ignores the filter, and ‘dvqid=117&query=...’ applies the filter but opens a temporary table report instead. Is there a way to dynamically filter a saved chart report?
How do I build idempotent workflows (so duplicates don’t get created)?
Hi all.Just wanted to know if it’s at all possible to perform an API call to a non Quickbase Site and have the data populate in another field without having to save the form for the API call to work.Was thinking maybe a button but docs suggest this won’t work.Any help will be appreciated. Cheers,Damien
Has anyone found a way to improve how the record picker works in grid edit?Say you are looking for the item that starts with CDV, When you type C it takes you to the beginning of the "C's" in the list and then when you hit D it jumps to the "D's" and so forth. When even using the default record picker in a form it doesn't have that behavior. I also tried creating a form for Grid Edit with a report for the picker and still reverts to single letter picking. Any ideas would be appreciated!
Hello, this is a fairly basic question.In a form for the child table, how can you change the fields that are previewed on the search bar. Example shown below:
It seems that timeline reports are not available to be slected when setting up a document template. Has anyone figured out a workaround for this?
I had a regular text field. When the text was long, it automatically wrapped. It was a plain text field. I loved that! I created a new table with the exact same table layout--but it no longer wraps! I can extend the field to see it all--but then it's awkwardly long. Or, I reduce the column width and it's cut off. Has QB eliminated the wrap feature for new tables?
It appears that the text does not wrap when the column width is reduced in the new report. Instead, the text becomes hidden and does not display ellipsis (three dots). To view the comments, I have to either set the row height to “Max” or open each record individually.However, setting the row height to “Max” makes the report excessively long and difficult to scroll, even when comments contain only a single line. Additionally, this setting does not display the entire comment within the defined column width, requiring me to increase the column width as well.
I have a read only report displayed in several places where IForms is used to supports user access to just what they need. Unfortunately, at the top of all reports there's a remaining set of links I can't seem to hide. Full report is at the left and you see in the screenshot there are others.I looked for any content on the subject but it seems to be years old and I don't believe the question has been posed recently. Is there yet a way to display a report suppress these features?
On legacy forms, when using a mobile device there were some ways to make a rich text button span the width of the mobile device. You could use:class='Vibrant' or in the styling you could use width: 100%.Neither of these tricks work on the new forms (on mobile). Does anyone know of way to make a rich text button span the width of a mobile device on new forms?
I have an application that the user creates child records in step 3 of the parent form. After the child records are created and saved it returns the user back to the parent form at step 1. Is it possible to change this so that when the child record is saved it returns the user back to step 3 of the parent form?
I'm experiencing an unexpected behavior when saving a child record and redirecting to its parent record using a Formula-URL field.Application structureParent table: Product request Parent DBID: bvcry7xy6 Child table: Products Child DBID: bvcry7xy7 Relationship field in the child: Related Request, FID 108 Parent Record ID lookup in the child: [RECORD ID# REQUEST (HEADER)], FID 186 Formula-URL field used as Save: FID 222The child record is initially opened using: URLRoot() & "db/" & "bvcry7xy6" & "?a=er" & "&rid=" & ToText([RECORD ID# REQUEST (HEADER)]) & "&ifv=1&hs=1" This structure work well untill 10/05 but now 11/05 I see this dialog message.
I've been playing around with the new forms, and form rules. One cool feature is the Success Modal/Notification. However, there is no option (as far as I can tell) to have it display when a field changes.It looks like you can display the message when a record is added or edited. So for example, if I want to display a success message when [Field A]="True!", my only option is to display message when [Field A]=True!This means, EVERY time a user goes to edit that record, the success message shows. When would that be useful? Why would you want a success message to show every single time a user is in a record, rather than when a certain action happens (the equivalent of 'when the rule changes from false to true')?My use case is I want a message to show when a checkbox is checked. And that's it. Just when it is checked, not every time anyone looks at the record and the checkbox happens to be checked.Thoughts? Has anyone used the success message in any helpful way?
Is there a way to clear or reset the icon/number of errors for a pipeline as a standard user? I couldn't find anything (perhaps just missed) within pipelines at the user level or pipeline level. Maybe a reset option could be added. Several of us go through testing the/their pipeline, fixing any errors, but then want a clean run with the errors indicator reset.
Getting an "invalid_grant" error after 24hrs. For the life of me I cannot figure out how to keep the tokens working past 24hrs. This pipeline runs every hour and returns updated refresh and access tokens. Everything works fine for 24hrs. This is from Inutuit Dev: "Tip: We update the value of the refresh_token value every 24 hours hours, or the next time you refresh the access tokens after 24 hours. This is an additional security measure by Intuit to reduce risk of compromise."Somehow refreshing both every hour is not meeting this requirement? We had a pipeline running every 12hrs also to get a refresh token separately but the results were the same. I feel like we are close, but just missing the timing of the pipelines or something else simple. PLEASE HELP!!I can provide more information beyond the two attachments as needed.
Hi Champions,Need your help for mentioned scenario, We have an application with 230+ rules with legacy form for desktop version. Now, we want to use the same application in mobile version. But we are facing challenges with complex rules that are not functional in mobile app. which was working fine in desktop. some of the challenges as below:After inserting the data and saving the form, but without values form getting saved Including mandatory fields are saving as blank in table.Popup messages are appearing in form after filling every field. which supposed to popup only once, if it meets the rule condition. HTML coded error messages are not appearing on form in mob. sometimes while saving the form unnecessary rules are getting triggered. and so on.....Alternatively, we planned to use a modern form but, modern forms are limited to 100 rules only and to use the modern form into Forms dropdown for Mobile section modern form is not appearing. QB support team says featur
Anyone have this? I can get it to work in a Rich Text, but those don't work on mobile. Would love to know if anyone has this in a URL button / formula.
Hi everyone, an iPhone, when viewing a form that has embedded report of child records - such as a service call record with child time entries - we cannot see the embedd report/table for the child records. This happens in both the web browser and in the mobile app.
Hi guys. I used the text below to create a button to update a text field. It works perfectly on desktop but on mobile it updates the field several times which I see since I track changes to that field. Any idea why it works on desktop but not on mobile?var text Approve = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=myapptoken&rid=" & [Record ID#]& "&_fid_295=Yes"; // change the 99 to the field ID# of the checkbox field var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();
I know that i can add a you tube video by adding the word embed. Has anyone added a recording from Teams?
Quickbase automations used to let me send an email directly from the Quickbase app, and the notifications option still lets me do this. However, If I want to schedule a notification on any basis other than record added, deleted or modified, it tells me I need to use a pipeline. Then in pipelines the only email actions are through 3rd party email services that I would have to give Quickbase my sign-in to use. There are two problems with this;I use my email to send encrypted private and regulated data and cannot simply let Quickbase have access to read and send my emails on my account without going through a bunch of extra red tape.I do not want Quickbase automated emails to originate from my personal email address as if I am sending them. Our email domain occasionally changes, and I will not always be with the company, when I leave, my email address will be deactivated, so the pipeline will be terminated.Does anyone have a workaround?
Hi all! I'm trying my hand at color-coding a report based on any records updated in the past 7 days. I found a few similar threads/tried to emulate the formulas, but it's giving me guff because Date Modified is a Date/Time field.My not-working formula is:If([Date Modified]<=Today()-Days(7),"green" My error says "The operator '<' can't be applied on types datetime, date #SendHelp! Thanks!!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.