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 U...
AshleyDeKerleg1
Quickbase Staff
Portland Qrew is meeting Wednesday, July 23rd, at 3PM PST at Harder Mechanical Contractors and also on Teams.
This month we'll look at DocGen lessons learned and alternative solutions. We will also...
JimHarrison
Qrew Champion
1 MIN READ
Join us!
July 9th at 12pm EST Quickbase's own Nathan Call will bring his Empower '25 presentation live to the Qrew!
Maria
Community Manager
The Content Feed
Feed
Upsert based on Condition
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!0likes0CommentsQuickbase University Is Launching New Experience on July 14th
📅 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 may be a brief period of downtime from Friday to Sunday, July 11-13, to complete the upgrade. 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? Your course history may not transfer. If a course you previously completed hasn’t been migrated to the new experience, it will not appear in your course history moving forward. For courses that are available in the new experience, our team is migrating completed course history over the next several weeks. 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. What will happen if I’ve bookmarked a link or have a link to the old Quickbase University in reference materials I’ve developed? No worries — we’ve got you covered! If you’ve saved or shared a link to the old Quickbase University, it won’t take you to the original experience anymore. But instead of hitting a 404, anyone who clicks that link will be redirected to a helpful landing page that introduces our brand-new Quickbase University. That page is designed to guide you (and your team) to the new experience — so you can quickly get back to learning, exploring, and growing your Quickbase skills. Search the new QBU for a link to the new version of the courses you've got bookmarked. We recommend updating your bookmarks and any reference materials with those new links to make sure everyone lands exactly where they need to be. And if you need help finding the right course or resource, we’re always here to help! Email us at university@quickbase.com with the specific course you're looking for. If it has been migrated as part of the newly curated offerings, we'll send you the new link. 🎉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 Team4likes0CommentsIncluding two classes in one button
I'm working with a rich text button. The button is on a parent record. The user clicks the button, the parent is saved, and then a popup opens to add a child record. When I add the savebeforenavigating class, the button stops opening the window in a popup and instead opens in a new tab. Is it possible to include both classes in the same formula? var number rid = [Record ID#];var text url = URLRoot() & "db/" & [_DBID_CHILDREN] & "?a=nwr" & "&_fid_10=" & URLEncode($rid) & "&ifv=1" & "&hs=1"; var text color = "#228B22"; var text txtcolor = "White"; "<a class='SaveBeforeNavigating' & \"OpenAsPopup\" data-height=\"800\" data-width=\"1000\" data-refresh=\"true\" " & "style=\"text-decoration: none; text-align: center; background:" & $color & "; color: " & $txtcolor & "; border-radius: 5px; margin: 2px; padding: 5px 5px; width: 100px; display: inline-block; font: 14px/ 'Calibri', 'Segoe UI', sans-serif; text-shadow: none;\"href='" & $url & "'>Add Child</a>"1like0CommentsJuly 2025 Qrew Meetup Event
Portland Qrew is meeting Wednesday, July 23rd, at 3PM PST at Harder Mechanical Contractors and also on Teams. This month we'll look at DocGen lessons learned and alternative solutions. We will also check in on moving Pipelines and setting up a separate Notification. We will talk about current projects, new changes and challenges. Anyone can show off work and cheer each other on to higher heights. We ask attendees to bring problems to solve and then work together to provide a solution. Anyone willing to share is welcome to have a problem solved by a team of very nice people who all love helping. Afterwards I suspect we will go out somewhere and welcome recommendations. If you would like to join remotely email jharrison@harder.com directly and he will send you a Teams invitation. Near Laurel Hill, OR1like0CommentsRefresh Connected Table Error
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]1like1CommentPipeline 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.Solved1like10CommentsHide Save Button on New Forms
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.Solved1like2CommentsUnduplicated 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!1like2CommentsHelp 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.Solved1like1Comment