Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Issue with native Save and Keep Working button.I have a form, on which are several fields that a user completes, the results of which feed into several GetFieldValues fields. These retrieves prices from another table based on the selections made. That part works fine, but then there are some additional calculations made using that price and other fields on the form, but the price isn't "retrieved" until the record is saved. Thus, the need for the Save and Keep Working option. But that button doesn't behave in an expected way.So I'm struggling to determine the cause within my environment when using the native Save and Keep Working button. First: after the first time this button is selected, the Save and New option no longer appears. And Second: sometimes when using this option, and just Save, the form saves but a new empty form is presented.Is there a better/different way I could save and continue mid-form data entry, so that my price retrievals occur, but allow the user to still have t
Is anyone using an expense management for users in the field to them import into QuickBase? We track expenses (expense table) to our projects. We are looking at apps like Expensify, Concur, Navan (or similar app) to capture receipts and data (most have an smartscan feature). We are looking to see if any app has a better connection to export data to QuickBase/Pipeline rather then manually sending the data over.
Hi all, hoping someone may be able to assist.Am using a pipeline to remove attachments using the format of 'fid_14=&delfile_fid_14=1'The result of this is that whilst the attachment looks to be removed from the form, it still is actually being stored (app file manager shows the attachments still exist).Has anyone else encountered this or possibly have a solution ?Cheers in advance.
I have created a table report by grouping the data based on a specific field. I would like to add totals and averages for a few of the columns in each group. How can I do that?
Hello Qrew! Hope everyone had a solid weekend! Quick heads-up: there aren’t any virtual Qrew meetups on the calendar this week, but there’s still plenty happening across Quickbase if you’re looking to connect or pick up something new: Sam’s Office HoursMonday–Friday, 1–2pm EDT No agenda, just bring what you’re working on and join the conversation. FastField Office HoursMondays, Wednesdays, and Fridays, 2–3pm EDT Hop in for tips and best practices, or just to see what’s new in FastField. Boston Qrew Meetup Wed August 20th, 4-6pm @MintzJoin the Boston area Qrew for an in-person event to network and share use case tips. Webinar: Feature Focus July & August ReleaseThurs Aug 21st, 1:00pm EDTJoin us as we review features that have come to Quickbase in July and August that you won't want to miss out on. On your own time: If you’re itching to learn something, check out the new Quikbase University experience. Lots of fresh cou
I would like to update my currently active notification’s permission type from Recipient to Open. Is there a way to do this without creating a new notification from scratch?Thanks in Advance!
What is the best way to verify that an email was sent using the Outlook channel's Send an Email step? I would like to update a record's status to Sent after I've verified that it's associated email has been. I don't see a way to reference the email's status or id after the Send Email step.I have tried a few things - 1. After sending the email, use the Search Emails step to find the email in the Sent folder. I create a secret key, put it in the email's body, but can't get this to work. I receive only the error: Validation error: {'query': 'required field'}. 2. We have the Sent folder already set up as a Connected table. I could force the table to refresh and then look it up there. There could be several emails being sent within the pipeline run, and I would have to do this in a loop which isn't ideal.Any other ideas on how to verify an email has been sent using the Outlook Send an Email step?
...was amazing, people! If you weren't there or you aren't a member of the group, check out a sample of what you've been missing! Here's EstherLaVielle's recap post with a link to the meeting recording! Check it out!
We have been using quickbooks for quite a while and it was brought to my attention yesterday that one of the reports that is constantly used is not functioning properly anymore and I am not sure what happened?In this report (attached) there are columns for;Job/item#/Description/unit price/Bid quantity/unit of measure/bid amount (tot) /quantity installed (tot)/ and revenue(tot)What is use to do was; take the unit price multiped by the bid quantity and that would give the Bid Amount (tot).Then the quantity installed would multiply by the unit price to give the revenue total (which still works for all of them).Now it adds the Unit Price for every daily log that our crewman enters that uses that item number.ie: the first highlighted on the report the 691,439.95 was multipied 3 times because there was 3 daily logs entered which is throwing off the whole total off the bid amount. The bid amount should be 691,439.95 but it has it as 2,074,319.85the other highlighted are doing the same be
I have a form with multiple tabs onto which I have embedded reports from related tabled. When the relationship was created a Report Link and and Add button are created. I generally do not include the "Add button" on my form as the embedded report has a built in Add option. I also know that on a form, you can specify whether or not to show that built in option.My issue is that I have an embedded report that isn't displaying the built in add option. I have confirmed: (1) that the form is not hiding this option, (2) that the table allows for new records to be created, and (3) that I have ample permissions to access the table and create records.What other reasons would cause this issue? As a side note, the form has 7 tabs, each with an embedded report, and this one is the only one not showing the built in add option.What obvious reason am I missing?
Hi team, Hope you are doing great! I want to configure my Quickbase app so that no user, regardless of their role, can download or export tables and reports. I’m looking for the best practices or settings to completely block these actions at the app or role level, without having to edit each report individually. Any tips or step-by-step guidance would be appreciated.
Hi,I have recently started facing this issue with my API call that I do from Alteryx to pull data from Quickbase table.I was working fine until last week Aug 1st, 2025 , but started to give no data then. I have provided the warning message that i get with Http 400 bad request error.Surprisingly there are other tables in my app that use the same headers and configurations (filters in query) which continue to work fine. I am unable to understand what to troubleshoot here. Do you have any guidance or setting that I could check?As a work around I tweaked the query a little bit removing filters adding number limits and then it works but that query cannot sustain for long. Please help. [Warning: Download (390): No data received from "https://******.quickbase.com/db/btdwv2ucy?a=API_DoQuery&query={'26'.XCT.'Complete'}AND{'26'.XCT.'Completed-Manual'}AND{'26'.XCT.'Closed Denied'}&clist=6.7.8.9.10.11.13.14.15.16.26.27.31.34.36.37.38.39.40.41.45.46.47&apptoken=**********66dxqt544&
I have two template tables that are related (Task template - parent and Subtask template - child). Both of these tables have a multi-select field called Task Category which could list property purchase, business purchase, lease, ground lease, construction, property sale, business sale as some tasks apply to multiple types of transactions. I also have the option of All if the task applies to any type of transaction. A transaction can involve several options - for example we could purchase the property and construct a building, or we could purchase a property and lease to a tenant. Upon the trigger of the pipeline, the appropriate Tasks are copied from the Task Template table to the Task table based on matching criteria. It works but I don't know how to add a 2nd step to also pull any tasks that are marked "All". I've attempted to add it within this statement as well as using AND but it errors . This is my current formula:
Hi, Is there any way to apply a dashboard filter to cover all tabs? The filter works fine when all the reports are on the same tab, but if I want to split reports across tabs, then it's very inconvenient to ask the user to select the same item across every tab to get what they want.e.g. You select the Project via the "Main" tab and it will filter all reports across the "Main", "Calendar" and "Issues" tabs for that selected Project.Thanks.
Hi,I'm the admin for our realm and wanted to know if I can reset the password from my admin console rather than the user doing the usual Forgot you password? method. Thanks,James
I'm trying to determine the best way to analyze records in a single table and return a list of records that had an entry 07-01-2025 but DON'T have an entry for 08-01-2025. I tried a simple table report that had 2 conditions Rate Date is equal to 07-01-2025 and Rate Date is not equal to 08-01-2025, but that just gave me the list of records that did have an entry on 07-01-2025. I'm trying to see which records from 07-01-2025 do not have a record for 08-01-2025.
I am trying to see if there is a way to create a pdf that is able to loop a section depending on how many children records are linked to the parent. Here is the situation. I have a site record (parent). Each site may have one or more visits (children). I want the PDF to repeat a template section for each child record. It will have information such as Start Date/Time, and Job Description. e.g I know Quickbase has an API to generate a PDF using a static template, but is there a way get it to loop a section in a template for each child record that exists? Having a different template for each child quantity possibility seems inefficient.Thanks.
Hello all, I'm trying to create a Save & Continue button for an add form that will return to the record to continue editing. I found this thread ( Add Save and Keep Working Button on form for a new record | Qrew Discussions ) from a few years ago which is exactly what I want to do, but it doesn't seem to be working as stated anymore. var text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=%%RID%%"; var text link = "<a href='" & $URL & "' data-replaceRid='true' style='font-size: 11pt;margin-left: 5px; margin-top: 0px; height: 33px; width: 160px; text-align:center;background-color:#13294d;color:white;background-image: linear-gradient(to bottom, #13294d 0%, #13294d 100%);' class='SaveBeforeNavigating Vibrant'>Save and Continue</a>";$linkWhen I click the created button I do see the "saving record" alert appear and then the green "Record saved!" but then directly after a window pops up "Leave site? Cha
Hello! Sam Trachy's office hours is cancelled this week and return Monday the 11th. If you need help with any challenges, feel free to post a discussion question on this site, join Discord to ask a question, or open up a support case with our tech support team. Thank you!
I am trying to see if I can find out when a report was created, & what user created it. I know that information is found at the bottom of the page in the tables, but I can't figure it out for the reports.------------------------------Laura Diak------------------------------
Does this function support capturing groups, and if yes, how does one access the captured data? Intent is to use a this function looking for punctuation from a text field, and then add a new line to this. regex: ([.!?])\s*substitution: $1\nDocumentation doesn't state one way or the other. I've tried escaping the new line value without success. Perhaps I'm just missing something simple.
Hello! I am a new user, and I'm looking for some clarifications on some of the specifics about how records, pipelines, and the callable pipelines action relate.I have a complex pipeline trigger by a user record creation. The pipeline runs through a substantial decision tree and updates records and sends notifications depending on the path through the decision tree the record takes.However, I have run out of actions and need to set up a callable pipeline to do some record validation (instead of adding those steps into the main pipeline).So, I am working on setting up the callable pipeline, but I want to make sure that the pipelines are only updating a given record, and not ALL records.-Update: before you read the next part of the post, consider that I may be overthinking this whole thing and I just need to pass through the record ID(s) for the records I want my called pipeline to validate.- I assume that when a pipeline runs with the "record created" trigger that the pipeline will
Hello all,I have what's sure to be a simple oversight on my part.I've likely been staring at this to long.In the following formula, the 1st 3 cases calculate correctly, but the last one does not.I know the why, but can't seem to figure out the fix.I have tried putting the closing ) in several places before and after the last /100 but can't seem to close off the Sum() function in the last case statement.Apologies for the inconvenience on this simple fix.Here is the formula.Case([Audit Status],"Abandoned",null, Case([Audit Type],"Inbound", If([Auto-Fail]=true,0, Max(0,Sum( Case(Left([IB-Field 1],1),"M",3,"P",2,"D",0,"N",3,3), Case(Left([IB-Field 2],1),"M",3,"P",2,"D",0,"N",3,3), Case(Left([IB-Field 3],1),"M",7,"P",5,"D",0,"N",7,7), Case(Left([IB-Field 4],1),"M",10,"P",6,"D",0,"N",10,10), Case(Left([IB-Field 5],1),"M",21,"P",10,"D",0,"N",21,21), Case(Left([IB-Field 6],1),"M",15,"P",
Does anyone know if there is a way to create a site-wide custom navigation header (custom buttons)? This seems like a simple and obvious capability, but I cannot find it, nor any posts about it.
I have a step in my pipeline that creates line items and inserts required data in that line item. The completion status of this line item is dependent on the field completed date.How do i include the completed date in the step so that when the data is added so that the line item is complete
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.