Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi Folks! A friendly reminder that there is not App Builders Qrew Meetup today. Our next Qrew Meetup is tomorrow Wednesday July 9th at 12pm est. General Qrew Meet Up: From Good to Great – Unlocking the Power of Reports (July 9, 12–1 PM EDT) Join Nathan Call as he shares pro tips on turning basic app data into visually engaging reports that drive smarter business decisions. Perfect for anyone looking to level up their reporting game. Here's the link to join our session tomorrow: https://quickbase.zoom.us/meeting/register/JW5Luqc_Ruqn3b7u0Hvdbw Thanks and we'll see you there!
Hi everyone! I wanted to give you an update from the Code Pages Qrew Meetup: All 4 videos of code page examples from our speakers are now included in the Code pages folder. Here's a quick recap of what they covered in the meeting and here's the folder to watch the videos: Code Page Example Showcase by Elvis Agyemang: Elvis showed off a personalized homepage and a world clock, both built in minutes using ChatGPT—proof you can spin up cool tools fast. Tips: Use AI like ChatGPT to draft code page widgets or dashboards when you’re short on time. Process Messaging & Pipelines by Eric Mohlman: Eric demoed a code page that gives live progress updates for pipeline tasks—no more guessing if your process is done. Tips: Use webhooks to trigger progress bars and auto-redirects for a smoother user experience. Pass record IDs in the URL to keep your code pages flexible and reusable across different workflows. File Upload Controls & Multi-Table Assignments by Simon Herbst: Simon walked t
Hi All,I have three tables. First is basic information, where people are marked as type A, B, or C.Second is the question bank table, containing all the questions for them. There are two columns for weight. If they are type A or B, they will see the column "weight - A or B", but if they are type C, they see the column "weight - C"Every time I create a new person record in the first table, I want to pull the questions and corresponding weight from the question bank to another table. I have created a pipeline (search records - add a bulk upsert row) to pull all the questions, but when it comes to the weight, how could I pull the corresponding weight based on their type? Thanks!
I built this summary report and need help filtering out duplicated clients. This report is built on the "Case Clients" table that is the many-to-many table connecting "People" to "Cases". I need this report to only show unduplicated people within each column. I have not used Help!
I'm getting this error when trying to refresh my connected table. I have no clue what I need to do to fix it. Help please. The error was: You do not have permission to import into the table. QuickBase API error: Insufficient permissions. Tracker ID: [4c5jvdi5z922]
I would like to have a pipeline condition where nothing happens if the current time is less than or equal to 30 seconds from the value in a given field, which is a date/time field. I have tried multiple variations of jinja code and mostly get the error message:Validation error: Incorrect template "whatever my jinja is". ValueError: invalid literal for int() with base 10: 'my_date_time_field_name'I have tried subtracting and converting the time.now and my field to an integer before comparing to 30 for seconds, I tried using time.delta(seconds=30) and adding it to the date field then comparing it to the current time, and some other things. I get the above error each time. I would really like to do this with Jinja, if at all possible. If anyone can help, that would be greatly appreciated. I know, worse comes to worst, I can add a helper field and just work off of that, but I am doing this for learning purposes. Thank you in advance to anyone who can help.
Do you want to remove the native Save/Cancel buttons on new forms or new mobile forms?Add &ifv=1&hs=1 to the form URL.They must be used together for it to work and this work in Edit mode.Note: It must be ifv=1 — other values like ifv=10 won’t work with hs=1.
i set up a report that lists each vendor and what states they checked off for service area, they are checkboxes, i don't know how to make it group all vendors that service alabama, all vendors that service alaska, all vendors that service arizona, etc...my ultimate goal is to create a search widget that will filter by service areai inherited this app and it was seriously lacking. i'm new to creating and working on app setups. i have taken the intro to app building and intro to pipelines courses so that i could make some changes and i just can't figure this out.
I am not a fan of Pipelines. I miss Automations. I used to be able to build an Automation in like 30 min and it did what I wanted. I've been working two days to build this Pipeline, even using the AI to do the framework, and I get nothing but errors or issues like this one.The intent of this pipeline is, if a record is created/updated in one app, it will look to see if there is a matching record in another app. If there is a matching record in the other app based on a site # & uniquely created identifier, it will update any modified changes in the second app. If there is not a matching record, it will create one in the second app.After tweaking several different things, I finally got it to create the record. At first, it was saying it was finding a record that matched the criteria despite no record being present. But now, whenever it does the search for a "Matching Record" based on the criteria I asked it to look at (site & unique identifier), it continues to have a FALSE findi
Hi all,I want to use a gauge chart the displays the number of records that contain the letter 'R' as part of a string of in a 'Job Number' field, out of the total number of records in the table.Typically a job number field value would be in the format of 00000_00, or 00000_A0, or 00000_R00. With R denoting revised.I've tried using a query report formula, but whilst it's a valid formula attempt, it displays 0. The total number of records for the gauge var text QUERY = "{6.EX." & Contains([Job Number], "R") & "}"; Size( GetRecords($QUERY))My logic to the above is that its querying the data table, for job number field (ID 6) to see if it contains a string with an 'R' in it, and if so count the total number of true records.Any ideas?It would be awesome if the gauge can be coloured to show the revised element in red, but the remainder of the gauge in green. But I really think that's beyond the limits of what is possible. However, if anyone has an idea how this could be acco
Hi,I have a pipeline that I'm using the bulk upsert steps for. Essentially, I'm just copying data from one table to another table and I need to do this bi-weekly. It's my first time using this bulk upsert and now I see there is a 250 field limit. Is there any way around this limit? I checked online and the solution seems to be to using a helper table, I'm not sure how to do this. I only have about 400 fields so I don't want to do that if unnecessary. I also saw something about a loop but I don't know how to do this either. What's the best way to go about this?I have the following steps in my pipeline:Prepare bulk record upsert Search RecordsIn Loop: Add a bulk upsert row - End loopCommit upsert
I have Table A and Table B. I would like to create a Report Link in Table A, which returns multiple records from Table B.In Table A, I have a text field called AllDataPoints with value:189-261 ; 189-21 ; 189-101(It was originally a summary field of combined text, i.e., multi-select text, so I can play around with the delimiters and such.)Table B has a field called MatchID (text). I want the Report Link to return 3 records from Table B -- the record with MatchID equal to 189-261, the record with MatchID equal to 189-21, and the record with MatchID equal to 189-101. In other words, I want records where MatchID is contained within AllDataPoints.I tried changing Value Matching to contains and wildcard. My guess is that it would work if values in A were substrings of values in B, but I want it the other way around -- return records where B is a substring of A.Any ideas? Thanks.
Greetings,I have been searching and experimenting for some time now. I have given up and decided to try posting, as everything I have found is not working so far. I have a dashboard that I would like to add a button to. The button is intended to make an API_AddRecord call and then return to the dashboard. I can get the API_AddRecord URL together and it works as intended. The desired record will be added successfully. I have the URL to bring up the dashboard as well. What I can't get to work putting them both in a formula URL that will return the page to the dashboard after the call is made. Can someone give me the structure for how this is to work? Thank you in advance for any input / direction you can provide.James
A lot of automation occurs in our application using imports. Most times it is an import from and to the same table to update content based on conditions.Problem: if you create a copy of an application, it appears that all the imports still point back to the original application name and tables. It would be simple enough if we could simply update the import target application name and have all the configurations update, but when you change the app name and select the table, all the import configs get lost, so you basically have to rebuild them all from scratch, risking potential human error. Does anyone have a known method out there for updating imports when copying an app?
Hi, I am having a Formula Rich-text button in Table report.But that is always enabled, even in view mode. How can I disable/deactivate in View mode?
After working with QuickBase Pipelines for years, one thing is clear: Every real-world use case is unique, from API limits and Jinja logic quirks to race conditions or silent failures. That’s why I believe we need more shared knowledge and real-time collaboration around building smarter Pipelines.What I’ve learned:Pipelines are incredibly powerful but not always intuitive.The best solutions often come from hands-on trial, error, and teamwork.Every failure teaches us something about logic, structure, or scalabilityWhat I’ve learned:Share lessons from the fieldExplore patterns that reduce manual tasks outside the systemLet’s learn by doing — together.#QuickBase #Pipelines #Automation #LowCode #WorkflowAutomation #NoCodeDevelopment #QuickBaseCommunity #APIIntegration #ProblemSolving
I have a drop down field that allows user to create new options, but I'd like to prevent people from adding any options with a specific key word. I thought I could accomplish this with a formula field that would just check if the drop-down field contained the key word. The problem I've run into is that it seems the formula fields are reading the new option as '_other' rather than what has been entered. I assume that is the placeholder that's used because the new option doesn't actually get saved to the drop-down field options list until the record is saved, but I cannot think of an alternative way to validate the field because of this issue. Here was my formula, just for reference: If( Contains([field],"Keyword"), Case([field], "Valid Option with Keyword",false, "Other Valid Option with Keyword",false, true), false)
I am trying to filter a report and am struggling to get the inverse of the if/then to show properly.I have tested the 'equal to' formula and it is working properly. i.e. I set a filter to be equal to that word so it only pulls records with that word in the field I am referencing.However, if I want the inverse of that report. i.e. I want all the records that do not contain that word to pull on the report however the inverse which I believe should just be switching the 'equal to' to 'not equal to' is not filtering the report at all. even though I have told the report to show me words not equal to the value I've entered are still pulling to the report. I can make a work around with multiple 'equal to' lines. I just believe that selecting the inverse of equal to should pull the records properly. TIA,Kbarry
We have an extensive Time & Expense app that I want to be able to add the receipt picture via the mobile device camera per expense record.Adding the expense is easy, but our current method of adding receipts is an event related table with a collection of receipts that are not oriented per expense (yes, that one fixable problem). Now, I could add the "Add Receipt" button to the expense record, but they still have to photograph the receipt first. I want to do this in one step - click the "add receipt" button, the camera open, take the pic, save to the expense record.Is there a way to do this while avoiding another expensive add-on like FastField license per user seat?Thank you,
Will @mentions be supported in pipelines whether posting to a RTF or MS Teams?
Hello everyone! Office hours with Sam Trachy will be cancelled the rest of this week and returning next Tuesday June 24th at 1pm EST. If you need support, be sure to reach out to the support team by accessing the ? on the top right corner of your account. More details here. If you want talk about strategy, performance, or growth, you can can reach out to your account team and they would be happy to help. Don't know who they are? You can access your Account Summary to view their contact info.
I am brand new to QuickBase, and have been asked to maintain an existing system where users rate various information presented on multiple tabs in a Form. The data presented in stored in records in a Table, and the selection made in the dropdown on the first tab determines which record in the table is imported to display on the Form. The only exception is the data that populates the various dropdowns, which in past was imported from a single Lookup list (think numbers - 0, 1, 2, 3). Each dropdown reflected the same scoring list (0,1,2,3).Now, we want to be able to populate each dropdown on each tab with a different rating scale (0-3, 0-5, etc.) based upon (1) the selection made in the dropdown on the first tab; (2) the tab number; and (3) which dropdown on the tab (each dropdown on a single tab could have a different rating scale).I have been researching, and I want to experiment during off hours, but if anyone has suggestions on how they may have accomplished something like this, I wo
Does anyone know of an add-on to Quick Base that either allows direct annotation and markup to a PDF within Quick Base or allows you to open it and auto save it back to the file attachment field? We switched from Wrike and one feature we all loved was that we could open an attachment with a system and make notes. It would auto safe to the record when closed vs having to download, annotate, and upload.I know it sounds trivial but with what we do we review PDF's and JPG's ALL DAY LONG and the constant download/upload takes up a lot of time and is a bit annoying.Thanks! Hope everyone is staying safe and healthy!------------------------------Ivan Weiss------------------------------
Hi, I want to use names from a text lookup field as the source of a multi-select field. Some lines of the text lookup field have multiple names which are currently separated by ";". On the multi-select field I want to display the individual options on a separate line. Is this possible?This is an example of what I have:Brand (Text lookup field pulled from a separate table)AB; CD; G; HE; FThis is what I want:Impacted brand (new multiselect field created)ABCDEFGHI want the user to be able to select multiple brands from the list
Hello!I'm diving into someone else's app, trying to wrap my head around their reporting needs.The previous admin created several "checkbox" fields that are in reality, types of answers to a master field. I need to tally each checkbox and ideally, I'd love to get this all on one report. I theorize the reason they did individual checkboxes vs. one multi-select field is because, in my own experience with multi-select, a report of such won't cleanly count how many times each item was selected, but will report out instances of the specific combination of what was selected.In my example, I'm tallying types of support received, where there are 10 sub-types as check-boxes, so ideally this report shows the exact count of each type of service counted.Please and thank you!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.