Resource Icons
Latest Highlights
Check Out The Latest in The Qrew
1 MIN READ
Hello Qrew!
EstherLaVielle , Maria , and I are always looking for opportunities to enhance The Qrew experience. As such, mid-year is a great time to examine where we are with our programs and w...
2 days ago
📅 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...
12 days ago
3 MIN READ
The Qrew is excited to bring voices from our Community into our blog. As both a current customer and former Quickbase staff member, Wes McAda is a long-time member of The Quickbase Qrew. If you have ...
2 days agoThe Content Feed
Feed
FYI: No Qrew Meetup Today! Next one is Wednesday 7/9/25
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!The magic of Service Accounts
We’re so glad you’re here! Today, let’s learn about Service Accounts and how they can help teams with multiple Realm Administrators or Builders working on integrations. Service Accounts are special admin accounts that let apps connect to Quickbase and use its data without needing a specific person to log in. This is super helpful when multiple people on a team are working together on integrations because it makes it easier to see who’s doing what and simplifies collaboration. Here’s why Service Accounts are important for your team: Transparency: They give a clear view of how and when data moves in and out of your apps, so everyone knows what’s happening. Security: They help keep things secure by allowing automated tasks without sharing personal login details. Continuity: They ensure processes aren’t reliant on any one individual. This helps avoid disruption. Even if someone leaves the team, everything continues running smoothly. For step-by-step instructions on setting up Service Accounts, check out our help article: Setting up Service Accounts. Feel free to ask questions or share your experiences with Service Accounts below…and happy building!AI & I
The Qrew is excited to bring voices from our Community into our blog. As both a current customer and former Quickbase staff member, Wes McAda is a long-time member of The Quickbase Qrew. If you have an interesting take or perspective on what's taking place in Tech today, and you are interested in writing a blog like the one below, please email Ben Simon at bsimon@quickbase.com. There are many AI tools and uses to consider nowadays. There is talk about it making many jobs, from artists to software developers, redundant. As a professional developer and an occasional artist, I have used AI for both. For example, my goofy, dad-joke loving side gets a kick out of this image: As a Florida State alum and football fan, and lover of both artiodactyls and beer, just “Yay!”. It is an FSU Efes Ewe, but I capriciously digress. I guess I could have paid an artist to render this, but I probably would not have spent the money on it. AI made this silliness accessible. AI also makes higher value work easier. When it comes to software development, I use AI to accelerate front end development work. With proper prompting, I can get code using HTML, CSS, and JavaScript that helps me go much quicker. I do not do a ton of front end work, but when I do, I rarely start from scratch anymore. The same goes for my Python scripts, which I sometimes use to get more out of the Quickbase API. More often than not, I use AI to get started. AI can also help provide alternative approaches for jinja templates that one may use in Quickbase Pipelines or formulas for Excel, SQL queries, or Quickbase formula fields. There are issues with the outputs, so users beware that you still need to know a thing or two about the subject matter and your context. One also needs to be careful providing inputs that may compromise confidentiality, security, or privacy. The point is that AI enables productivity so that I can focus on impact. AI also helps me in ways that other services like Mockaroo or Canva might; I can get downloadable mock data per my specifications or color palettes in hex codes for my colorblind development work. AI helps avoid a tedious task or facilitates my handicap in this case. One area in which there is professional/personal crossover with AI is writing. Anyone who has coded or developed a Quickbase app is familiar with the struggle of figuring out what to name variables or attributes. However, when writing emails or even something creative like one of my recent haikus, AI helps me with words. AI does not write for me; it helps me write better. The AI tools that I generally use are Copilot and ChatGPT. I have also created agents in Boomi, but I am in early stages on how to incorporate a trained agent in a workflow yet. I am looking forward to Quickbase’s forthcoming MCP server offering with great anticipation! My expectation is that enterprises will profit greatly from AI agents when we gain greater confidence in AI’s security and can leverage its processing power on premises. But what interests me most about AI today is how other devs like me are using it. What are some ways others in The Qrew are using AI? Share below!Update to Code Page Example Folder: All Videos Included
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 through file upload controls that check file type and size, with instant feedback using Bootstrap and Vue.js. Tips: Make your file upload page portable by passing table and field info in the URL—one page, many uses. Use real-time validation for file size and type to give users immediate, clear feedback (and avoid frustration). “Quicksheets” Code Page by Andrew Carbejal-Everts: Andrew recorded a short video on how to use code pages to export data to Excel to email different reports in a single file. Interested in reviewing their code page examples and using it for your use case? Here’s a link to a folder that has Code Page examples from Elvis, Eric, Andrew, and Simon. All videos included. Please let us know if you have any questions and we'll be sure to have experts review and respond. Thank you!Qrew Events the Week of July 7th 🚀
Hey Qrew, Hope everyone had a nice restful long weekend. Here’s what’s happening at Quickbase from July 7th–13th: 🌟 Featured Events: 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. Webinar: Will SaaS Sprawl Cost You Your AI Transformation? (July 9, 12–12:45 PM EDT) Discover how SaaS overload could be slowing your AI initiatives and what you can do about it. Don’t miss the latest research and practical solutions1. 🌟 Bonus Event and Activities: Quickbase University Launches New Experience July 14th!Click the link to learn more about how it will change next Monday. Take this mid-year community survey We are always looking for ways to improve and bring more value and fun to the Qrew. Please take a moment to share your thoughts. The survey is open from today to July 31st. Mark your calendars, bring your questions, and let’s make this week awesome! Best, Maria
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!2025 Mid-Year Community Survey
Hello Qrew! EstherLaVielle , Maria , and I are always looking for opportunities to enhance The Qrew experience. As such, mid-year is a great time to examine where we are with our programs and what we can do differently to improve. Please take a few moments to answer a few questions about our Community, The Qrew, via the below survey. SURVEY Thank you to each and every individual who makes this Community what it is. From our amazing customers, our devoted partners, and our passionate staff, we all bring something different to The Qrew. I'm looking forward to seeing this Community continue to grow and flourish. -Ben
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!
