Resource Icons
Latest Highlights
Check Out The Latest in The Qrew
Hello Qrew!
We’re thrilled to launch a brand-new series called Certification Wins — your monthly spotlight on the amazing individuals across our community levelling up with Quickbase certification...
15 hours ago
2 MIN READ
Quickbase Admin Getting Started Guide
If you're new to being a Quickbase admin, start here! While it may feel like there is a ton to learn, the Getting Started Hub has you covered. This is how...
18 days ago
Ready for a chance to win and boost your Quickbase skills?
The App Builder Qrew is hosting a raffle giveaway—simply download Mark Shnier’s app from the Quickbase Exchange and show proof (a sc...
14 days agoThe Content Feed
Feed
RegEx replace
Hello, I'm trying to implement a regex replace to remove all special characters from a field. However, it's not working as expected. The result still shows certain special characters and line breaks. Here is an example. Could you provide the regex pattern you're using and the example text? This will help me understand the issue better and offer a more precise solution. RegexReplace([field_name],"[^A-Za-z0-9 ]", "") If you have any ideas on how I can refactor my formula, I'd love to hear them!
Mandatory Multiple Attachment for a Record
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. Kindly suggest the better way to add multiple attachment for a record, even user missed the attachment it should not allowed them to save and let them add attachment without refreshing the page. Thanks
YTD Reporting-Best Practices
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 and pull the YTD report from that table? I would just like any input/advice from someone more knowledgeable than myself. I am hoping I am thinking about this in the right way. Thank you, Kim🏆 Introducing: Certification Wins – A Monthly Celebration!
Hello Qrew! We’re thrilled to launch a brand-new series called Certification Wins — your monthly spotlight on the amazing individuals across our community levelling up with Quickbase certifications! 🎉 Every month, we’ll be celebrating those who’ve earned their credentials across these key certifications: Whether you're just beginning your journey or pushing the limits of what's possible in Quickbase, Certification Wins will honor your growth, dedication, and success. 🎯 What to Expect Starting next month, we’ll publish a list of achievers who earned certifications in the previous month. We’ll also highlight standout stories and give a special shoutout to one lucky certified user with a small reward! This initiative is about recognizing YOU — the builders, thinkers, and doers driving innovation daily. ✨ Stay Tuned! Our first edition drops soon, so keep an eye out… You might see your name up there! 👀 And if you haven’t gotten certified yet, now’s the perfect time to jump in. Until then, build bold and celebrate big. See below for a few extra resources to get you started on your Certification journey! Quickbase Certification Central Read about Certifications here!Office Hours with Sam Trachy Cancelled 4/28-5/1/25
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.
Boston Qrew Meetup - May 21, 2025
Great News! I'm excited to share that we're bringing back monthly in-person events. Starting in May, we'll be hosting Boston Qrew Meetings on the 3rd Wednesday of every month. These meetups are a great opportunity to connect with other Quickbase users, get help with your apps, share ideas and challenges, and hear from Quickbase product experts about new features and updates. Whether you're just getting started or have been building for years, there's something for everyone. Upcoming Meetups: May 21 (4–6 PM) Quickbase, 255 State Street, Boston Guests: Ryan Murray, Heather Karas, Sam Trachy June 18 (Time TBD) Quickbase, 255 State Street, Boston Guests: Scott Galloway, TBD July 16 (TBD) – Boston August 20 (TBD) – Boston If you’re interested in joining us on May 21, register here: https://resources.quickbase.com/nav/app/buzeg8mdy/table/bu2pvgz53/action/nwr?originalQid=td&page=1 Hope to see you there!Need help deciding between two db setups
I am pretty new to qb and am currently trying to create an app to help my department track a student's requested thesis committee. The (hopeful) process: student will submit form with their identifying info, proposed thesis title, then choose their requested thesis supervisor, and selected reader, both fields pull from the same list of faculty (though if someone is chosen in one field they will not appear in list in 2nd field - that's for another time to figure out). So in trying to build something I came up with two different setups and am wondering which people think would be best. Which do you think will be better longterm. Attached are screenshots of both relationship diagrams. Hopefully they are decipherable.How can I avoid saving a form if I need the user to create another record in a related table first?
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?
How to manage HTTP "accounts" in Pipelines
I'm using the HTTP "Make Request" step in several pipelines to make HTTP calls from Quickbase to my applications API. The way you configure the URL and authentication information for that API is via the "Connection" where you configure an "HTTP account". I can see how to create a new "account" there, but I can't figure out where to update or delete those accounts. I've searched the Quickbase UI and couldn't find anything, and the docs didn't contain anything that I could find. I considered using "variables" to try to specify my URL and reference the variable in the "HTTP account", but that context doesn't seem to support variables, which seem like they were built for use in formulas, not pipelines. Can anyone tell me how to manage (edit, delete) my HTTP accounts used in my pipelines? Thanks!
