Resource Icons
Latest Highlights
Check Out The Latest in The Qrew
📅 What’s Happening and When?
We’re launching a new Quickbase University experience on Monday, July 14 th !
🤔 Why the Change? You spoke. We listened.
The current Quickbase Univ...
4 days ago
1 MIN READ
Tuesday, June 24 – Code Pages Qrew Meetup | 12:00–1:00 pm EDT
We’ll kick things off with a quick intro to code pages, share some handy tips, and walk through real-world examples from both custom...
8 days ago
Quick Update:
Doc Creation via the Quickbase Pipeline Channel is being pulled from this release to give our team time to look into an issue, please refer to our future release n...
8 days agoThe Content Feed
Feed
Unduplicated people summary report
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!
Pipeline Jinja For Duration in Seconds
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.Quickbase University Is Evolving: What You Need to Know About the Upcoming Launch
📅 What’s Happening and When? We’re launching a new Quickbase University experience on Monday, July 14 th ! 🤔 Why the Change? You spoke. We listened. The current Quickbase University hasn’t fully delivered the learning experience you deserve. So, we’re making bold improvements—from modernized courses to smarter certifications—to help you learn faster, earn recognition sooner, and showcase your Quickbase expertise with confidence. This is more than an upgrade—it’s a whole new way to grow with Quickbase. Here's how this transformation will revolutionize your Quickbase learning journey: 🎓 Next-Level Learning for Next-Level Builders Our enhanced learning platform is: Intuitive & Engaging New and improved courses with fresh, relevant content Intuitive navigation that gets you to content faster Improved search capabilities to find exactly what you need Advanced progress tracking with detailed analytics to monitor your growth Personalized & Efficient Personalized learning paths that adjust to your role, preferences, and pace Bite-sized learning modules designed for your busy schedule Mobile-friendly, web-based experience so you can learn anywhere, anytime 🏆 Certifications You Can Share With Pride Get ready for more streamlined exams and recognition that opens doors! Streamlined & Secure Exams Streamlined navigation making the exam process smoother than ever Immediate results with instant feedback and detailed performance analytics Enhanced security features ensuring exam integrity Comprehensive & Recognized Certification Badges Blockchain-verified digital badges that are tamper-proof and instantly verifiable Social media integration for easy sharing on LinkedIn and other social platforms ❓Frequently Asked Questions Access & Login Will there be any downtime? There will be minimal downtime the weekend of July 11 th as we get ready to launch our new and improved experience on July 14 th . Where can I find the new Quickbase University? We’ll be maintaining the same URL for Quickbase University: university.quickbase.com How will I log in? There will be no changes to how you login. Use your Quickbase credentials, either from your organization or via your Builder Account to login. Having trouble logging in? Try resetting your password, clearing your cache, or switching browsers. Courses & Certifications What will be available on the new platform? We’re launching a refreshed catalog with 500+ curated assets that reflect our latest and most relevant content, including NEW On-Demand path to Pipelines Certification! Most older courses will be retired to ensure you receive the most accurate, up-to-date information and best practices. Will my course history transfer to the new Quickbase University? Some, but not all. We’re bringing over only the completed courses that will still be available on the new Quickbase University. Courses in progress will NOT transfer. Completed courses will only transfer IF: The course will still be available on the new platform, AND The course was completed by July 7, 2025, AND You’ve logged into QBU on or after July 1, 2023 If you haven’t logged into QBU since July 1, 2023, your account and course history won’t be migrated, but we will archive the data. If you are seeking this information, please contact us at university@quickbase.com. What about my existing badges and certificates? You will not find links to your certifications in the new QBU, though any certificate and badge links you’ve bookmarked in the past, or have stored in your email, will remain live. If you need access to these links, you can email university@quickbase.com and the Customer Education team will have that data available to share with you. Can I download my certifications ahead of time? Yes, up until July 11 th , you can login to the current QBU to download any certifications you’ve earned to date and/or bookmark links to that information. Support & Troubleshooting Need help during the transition? Comment on this thread! If your question contains confidential information, please email university@quickbase.com. We’re here to make your transition to the new Quickbase University as smooth as possible. 🎉It’s a New Chapter for Quickbase University As we embark on this exciting journey together, I want to personally thank you for being part of the Quickbase University community. This upgrade represents our commitment to providing you with the best possible learning experience, and I'm confident this new experience will help you achieve your goals faster and more effectively than ever before. Looking forward to learning alongside you in our new digital home! Ashley and the Customer Education Team
Help with searches...
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 area i 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.Southern Companies is Seeking a Quickbase Developer / Engineer - Kilgore, TX
Southern Lifting and Hoisting, LLC and Southern Transport, LLC Job Title: Quickbase Developer / Engineer Location: Kilgore, TX Employment Type: Full-Time Department: Operations About the Role We’re seeking a driven and solution-oriented Quickbase Developer / Engineer to lead the development and optimization of our custom-built applications across key operational workflows. This is a high-impact role for someone who thrives in fast-paced environment and wants to transform how field teams, equipment, operations, maintenance, and financial data are connected. You’ll be at the center of designing scalable solutions while engineering back-end logic, and seamless integrations with other platforms (e.g., Power BI, SharePoint, Office 365, Samsara, Paychex, and more). This is more than just building apps - it’s about building infrastructure that drives and enhances performance across an enterprise of business operations. *This Role will require frequent travel to throughout TX, LA, OK, and WY. For more information about who we are, check us out @ www.southernliftingandhoisting.com or www.southerntransport.com Ready to engineer impact? Submit your resume and a portfolio of Quickbase applications or examples of relevant work to: chad.pinkston@southernliftingandhoisting.com] Subject Line: Quickbase Developer Application – [Your Name]
Pipeline Error trying to Create a Record
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 finding and just creates a duplicate instead of updating. And the Activity log seems to say that it couldn't find the record based on the search criteria but created duplicate records with the exact criteria it was asked to look for. (I now have 5 records with identical site #s and unique #'s. What am I missing to get it to have a TRUE finding of the record. Also, is there any way to change the "Query" to look at anything besides the Record ID??Data Change Logs Just Got Smarter!
Having visibility into what changed, when, and by whom, and being able to restore previous values is essential to every software we use nowadays. This is even more important for maintaining trust, accuracy, and control in your Quickbase apps. That’s why we are rolling out a major upgrade to our Audit Logs and particularly to Data Change Logs - giving admins a more powerful, reliable way to track and recover data changes with (almost) zero setup required. What’s New in a Nutshell All scalar fields are now tracked by default once auditing for an app is enabled - no manual enabling needed Only actual field changes are logged - cleaner, more relevant audit trails App admins can now restore changed and deleted values - right from the app audit log Existing field property repurposed - now controls presence in change logs, not logging behavior See full release notes Let’s unpack the details. Easier Setup: Track All Scalar Fields Automatically Previously, tracking data changes required manually enabling individual fields one by one. Now, all scalar fields (like text, numbers, dates, checkboxes, and more) are automatically audited as soon as auditing for an app is turned on. Realm admins can enable data change logs for a particular app from the Admin Console Apps page: As soon as data change logs for an app are enabled, we will start tracking any data changes for all scalar fields in the app. The changed data will be stored at a record level. Here’s an example data change log event for a single record (both in app and realm audit logs): Once you click on the “View data changes” link, the following modal is displayed: The pop-up will contain the previous and current values for all fields from the record where data changes have been made. That same information is also available in JSON format in the CSV export, as well as in our Audit REST API. A Smarter Use of a Field Property We’ve also updated the meaning of the Track field property (Table settings ---> Fields ---> Field Properties) Before: This determined whether the field was tracked at all: Now: All scalar fields are always tracked. The repurposed field only controls whether the field is always shown in the record change log, no matter if the field data has been changed or not: If you already have an app where data change logs had been previously enabled, we will automatically start tracking all fields. However, you may want to do a clean-up and uncheck the repurposed checkbox for some fields to avoid them being always unnecessarily present in the change log entries. You should also keep in mind that if you disable data change logs for an app that had tracking for certain fields already enabled, the setting for these fields will persist the next time you enable data change logs for that same app. Restore Changed Data Instantly This one’s a game-changer: App admins can now restore a field’s previous value directly from the app audit logs. This works both for updated and deleted records. Whether it was a bulk update gone wrong or someone changing the wrong record, app admins can recover from data mistakes in seconds - no need to dig through manual backups, contact tech support or manually re-enter data. What you need to do: Locate in the logs the record that you want to restore, click “View data changes” Select the fields you want to restore - all of them or specific ones Click “Restore previous values” Upon a successful restore, you should see a message like this: You can also restore any deleted record as a new record: • Note • Keep in mind that the data restore option is available only in the app audit log. Data change logs are available in the realm logs, but realm admins do not have the ability to restore data. This is intentional, as we would like to keep the restore closer to where the data lives. Designed to Scale Some of you generate millions of audit events every single day. As part of this change, we thoroughly evaluated the platform performance to ensure app experience and audit performance are not impacted. The new changes are not going to affect your app space entitlements – audit is a separate service. We also decided to retain the existing limit of 50 auditable apps per realm. While this may change in the future, we want to better understand your usage patterns, compliance needs, and platform behavior before potentially enabling higher app limits. The Big Picture Data change log updates are part of a broader investment in powerful, scalable audit capabilities. Read our recent blog post for details on other recent audit improvements. Try It Today If you’re already using Audit Logs, these enhancements are live now. Easy setup. Built-in restore. Smarter logs. Less noise.Counting Instances of String across records for use in a Gauge Chart
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 accomplished, that would be absolutely appreciated!
