Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hey QB Ladies! For anyone who is local to Boston, I will presenting at the Boston Qrew Meetup on May 21. My focus will be on new forms, old forms, and how to use both to their strengths! Boston Qrew Meetup - May 21, 2025 | Qrew Discussions
Hi all!Looking for ideas on how to draft a report that will tally how many records have more than one checkbox checked (of a series of defined checkboxes). Please and thank you in advance!
I have a User Focus table that has worked without any issues for nearly a year. Today, a user let me know that records stopped appearing on their end partway through the day (the API_RunImport call needs to work for them to see the records on their end once created). The first 12 records they created worked fine, then suddenly, new records stopped behaving as expected.After some investigation, I found that the problem is due to the Record ID (RID) from the source table not being written to the User Focus table. This breaks the subsequent API_RunImport, since there is no RID to tell the import which record to merge with. The workflow was still working fine earlier today, then stopped without any changes being made.Context:I am the only builder for this app and no one else has access to change fields or formulas. No recent changes have been made to the fields involved. I have run several tests, but the RID ([Record ID#]) is consistently not being passed through anymore.All other fie
Good Afternoon Everyone,Would love to hear if anyone has solved how to use the Quickbooks online channel to pass along that an item is "Taxable". All settings are correct in Quickbooks online and in Quickbase. I just dont see the option to have it check the "Tax" checkbox in QBooks Online when creating the invoice.
Figured out my first one (well, kind of). I'm building a summary report summarizing several check-box fields.Two questions:Is there a better way to do this where I want summaries of a LOT of check-box fields? It looks like the cap of line items to summarize is 24Do I have to "Group by Rows"? I basically just want a total summary, but don't want to group it. Speaking in Excel terms, what this might look like in an ideal world is:Rows that are limitless, identifying each field to summarizeColumns are only two -- 1) The title of the field being summarized, and 2) distinct count Here is what I'm looking at, and I ended up just creating a summary field generally to just have one summary row.... but really, I just want the bottom line.
Is anyone haveing trouble with lookup fields on the new forms not populating? I have switched a few forms to the new style and it seems to now want to populate the lookup field sometimes the search function will pull in a result but 99% of the time it just says 0 results I have over 400 choices in this field it usually shows me the first 100. Is anyone else expierencing these issues?
Hi, I have a use case where I have to attach the multiple attachment for a record and if the attachment is not attached then it should not allowed user to save the record. However, I have created a separate table for storing attachments and formula url button in parent table which redirects the user to the child table to create the record for Attachment and created dynamic form rule if Attachment required =yes and #of Attachment =0 abort save.But the issue is if user have provided all the details and missed to attach the attachment it is not allowing user to redirect to another page for adding attachment without saving the record and record cannot be saved because user has missed the attachment and if user wants to attach attachment they have to refresh the page first which results in loosing all the data which user has filled in the form. If I change the URL properties to popup window then also attachment will not be visible until user refresh the page.  
Hello! I am working on a monthly and yearly sales report and I have run into a hiccup. Scenario: I have a record that is a booking ("sale") that is made in Jan 2025 and then in Mar 2025 the booking is cancelled. The way I have it now is that when the booking is made, the status field changes from quote to booking and then when cancelled, the same field changes to cancelled. In my YTD report, this is causing the booking made in Jan 2025 to not show up due to the cancel in Mar 2025. I understand it is a wash, but I still need the booking to show up in Jan 2025 and then the cancel show in Mar 2025. So, this is what I am thinking for a solution: Create a date field unrelated to the status field that will populate when a cancel occurs and have the report pull of the booking date/status and also from the cancel date report and that should then show both transactions OR create a separate table that will hold the numbers at month end for each month
I have a Parent Phonenumber table and a child Callhistory table. I would like to get the latest comment for the phone number from Callhistory table. Is it possible to get the max of record id for the phonenumber key using formula.
Hi folks! Just wanted to give everyone a quick heads up that Sam Trachy's office hours is cancelled from Monday 4/28 to Thursday 5/1/25. He will be back on Friday 5/2/25 at 1pm EST to resume office hours. To register for the next meeting, you can check out the quickbase.com/events page. If you need help, we recommend to submit a support ticket, ask questions here on the discussion site, or on Discord.
Hi I need support with the following issue, I have created a form. This form contains a button to add more product requests. But many times users do not add products to the request and the request remains open and empty, unattended and incomplete. Until the user comes to upload products and in the form selects that no more products need to be added, Quickbase executes rules and notifications to complete this multiple or single product order as completed and processes the request. The problem is that I don't know of a way to prevent them from creating and saving the empty product order. Is there any way to achieve that result?
I'm trying to get an embedded (report link) Grid Edit report field to return a pre-filtered conditional dropdown list similar to how a Form field can filter based on a report. This is a Legacy Form. In screen shot 1 one can see a conditional dropdown list of Standard Deliverables (conditional on Discipline) that filters out Obsolete (checkbox field) deliverables by using the Form's "When Used for data entry:" filtered dropdown report. (filtered Obsolete not equal checked)I'm trying to replicate this behavior in an Embedded Grid Edit report, however, the full list of deliverables including the obsolete deliverables are showing up (eg. 3300 Utilities and 3610 Fabrication Drawings) and there doesn't seem to be an obvious method to pre-filter this dropdown list (ie. pre-filtered report). I've done some reading on the subject in these discussions and the following discussion seems closest (https://community.quickbase.com/discussions/quickbase-discussions/embedde
Is there a formula that I can remove one space?Ex: Kathy Benjamin to Kathy BenjaminThank youTh
I am not sure why I am getting this error in my pipeline. invalid literal for int() with base 10: 'user'------------------------------Melanie Proebstel------------------------------
I have an app with the following setup. IVRT and ARHIFU are parent tables.All Patients is the child table.In All Patients, I have lookup fields pulling in patient name report link fields from both the IVRT and ARHIFU tables:[IVRT Patient Name Link] (from IVRT)[ARHIFU Patient Name Link] (from ARHIFU)These lookup fields correctly show the patient names as clickable links in the All Patients table.Now, I would like to display the clickable links from both of these parent tables under one field in the All Patients table. (See attachment).The problem I am running into is keeping them as clickable links. How can I display the clickable links from both parent tables under one field in All Patients?If a formula is needed to achieve this, what would that formula look like?Thank you!Meagan
Hello,I have a Quickbase app where a single child table is connected to three separate parent tables. Each parent table represents a different employee group, and the child table is set up to pull employee information from all three.In the form for the child table, I want to be able to look up and select employees from any of the three parent tables. However, I can only select from the first parent table I connected—its lookup field is active. The lookup fields for the other two parent tables appear grayed out and are not selectable, even though they are all connected in the same way, using the employee name as a lookup field.As shown in the screenshot, only the first table’s name field is selectable, while the others are disabled.What might be causing this behavior, and how can I make all three lookup fields usable in the form?Thank you!
I have a table called "Rapid Notification"I have another table called "Water Systems"Within rapid notification, you have an option that says, "Send to Who?" If the option says "POC" (Point of Contact.)Within water systems, there is an email field for our POC's. What I want:When I add a new Rapid Notification, AND Send to Who? is POC, send an EMAIL to ALL water system POC's. I want to set this up through Pipelines. I cannot figure out how to get it to send it to ALL water systems. There is a relationship between the two. Each water system has many Rapid Notifications. I tried going the other way as well. Each Rapid Notification has many water systems, however, when doing that we have to go to each individual water system and assign the related Rapid Notification to each water system every time we add a new Rapid Notification and its too time consuming so I removed that relationship. We use the rapid notification for many reasons - sometimes we send a rapid notificati
I have a List - User field called "Leads" in Property table and want to build an automation to create individual record in another table called "Team Role", so that users added to Leads field can be displayed in a table row. The search pipeline step allows creation of record for the first user added to the list, but skips the other values from the List - User. If there is any alternate approach for this, please let me know.
I have an app where I run a daily upload of data (much of it duplicate due to the nature of the source), but sometimes my daily upload includes a new record that needs to be added to a secondary table within the app. The key field in the secondary table matches one of the fields in my daily upload. I have set up a QB action that should identify new unique values in the field related to the secondary table's key and copy these records. But I am running into a problem. Sometimes my upload will include several rows with the same value in the field that I want to use to populate the secondary table's key field . When this happens, my action is registering an error. I only need the value in one of the duplicate lines to write to the secondary table, but I need to preserve all of the lines in the primary table. Any suggestions?
Does anyone have a template or know how to Print on a dymo label maker from exact forms?
I'm finally moving a product pricing process from EXCEL into QB.The last step is giving a user(s) the ability to print product labels from QB to a local DYMO printer. What I had envisioned was a button on the record form that would take a half dozen or so values in the record and push them as values for the label.Has anyone here done this already? If so, are you willing to share any of your scripting?My JavaScript experience is extremely limited. This link is an example of printing to a DYMO via a JavaScript library, but I don't really understand how to set the values of QB fields as the values to send to the printer.http://developers.dymo.com/2010/06/02/dymo-label-framework-javascript-library-samples-print-a-label/Any help would be greatly appreciated.
I have a pipeline that logs when a record was changed in a tracker table. I need the date/time of the change to be accurate to the second. I can't have a pipeline copy the Date Modified of the source record to a Date/Time field in the status change record as we would lose the seconds.I can't use the Date Created of the record created by the pipeline as this and the user's action are offset by a second or two. I need this to be when the user made the change, not when the pipeline created the record.I created a Formula - Date/Time field in the source table that is ToUnixTime([Date Modified]), then the pipeline copies that to a Number field in the status change record. This works, however I'm in search of a more elegant solution than creating a formula field in every table that needs this.Is there a Jinja expression that will give me the ToUnixTime() of Date Modified without having to create a formula field?
Hello,I'm trying to create a text field called "Reporting Year" where users can only enter numerical values for a year (i.e., 2023). Also, I need the field to be auto-populated with the current year (i.e., 2025); if the users wants to change this, they can do so. I haven't been able to completely figure this out on my own, so I appreciate any help on this. Thanks in advance!
I’m in PR and we use QB for managing our media requests. If a reporter reaches out with an inquiry we log it in a media requests table. Media requests has a parent table of reporters (reporters can have multiple requests). Each reporter has a media outlet (think CNN or ABC News) parent (a media outlet can have many reporters. One of the things we track is the coverage of the media requests generates and score it with a multiple choice field on the media request entry (positive, negative, or neutral). So I have a pie chart that show the breakdown of the coverage with those options. I can pull that report into the reporter table on place it on the reporter form and it filters it down showing the score for that reporter across all their requests.What I want to do is pull that data into media outlets so I can see the score for that media outlet across all their reporters and the reporters requests.I want a similar pie chart on the media outlet form.What’s the best way to go about this
Dear QuickBase people,The slower speed/performance of QuickBase appears to be directly corelated to the amount of unwanted "New Features" nobody is asking for.Just sayin.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.