Resource Icons
Latest Highlights
Check Out The Latest in The Qrew
1 MIN READ
🎓 Hello Qrew!
We’re back with our August Certification Wins, where we proudly spotlight the amazing individuals in our community who’ve earned Quickbase Certifications this past month!
Each cer...
5 days ago
2 MIN READ
Life comes at you quick. Releases come at you quicker.
Welcome to the September 2025 Release Enablement here at Quickbase
As you might have heard, our new Release Notes App is going to keep you ...
14 days ago
3 MIN READ
Quickbase helps you unite scattered information into one place, giving you complete visibility across your workflows. That means faster, more informed decisions. Visualizing your data with charts sup...
15 days agoThe Content Feed
Feed
Help! Formula Query with multiple conditions.
My query is not returning any value for records that meet the conditions. ToNumber(ToText(GetFieldValues(GetRecords("{86.EX.'"&true&"'}" & "{15.EX.'"&[mhe_type]&"'}", [_DBID_BTS_METRICS]), 10))) I need to return the field value (fid 10) from the table [_DBID_BTS_METRICS] when field ID 86 in the queried table is true (checkbox is checked) and the value in field ID 15 is equal to the value in the field [mhe_type] in the querying table. I have tried: punctuation, format, etc numerous times using a text field to give the checkbox a yes/no value and using that field (fid 89) in the conditions in case it is the checkbox giving me the problem changing it to a SumValues query, but then it returned a value of 0.
Map Report
I would love to use a map report to see how many clients come from each zip code, but currently the map will only show the first 100 clients. Is there a workaround for this where I could have each pin represent 50 clients? Or even just have one pin per zip code and hovering over will show the number of clients? I would really love to be able to have a visual element for this data, and my current summary report is long and clunky. Thank you so much! ------------------------------ Hunter Collins ------------------------------Dashboard Maps are actually awesome
Just FYI, and not a question ..... I just did my first production map report with hundreds of pins ( 610 pins to be exact!) on the Dashboard and OMG, you really have to give Quickbase credit for this one. The map loads super fast and as advertised, I was able to customize the pin colour and pin icon. They also did quite a nice job of handling the situation where multiple pins are at the exact same address. Kudos to some unknown software engineers and Product Manager for nailing this one. ------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------Configuring Your New Account
Table of Contents 1. Accessing your Account Summary Page 2. Setting up your Account Properties 3. Your Account Permissions 4. Change your realm’s URL 5. Reviewing and updating your Billing Account Admin 6. Setting Default Permissions for your Users 7. Further Resources These settings will decide who can create new apps, build automated workflows, and administer your account as well as technical settings like how each new app handles things like currency symbols and time zones by default. During your trial or initial account creation some of the defaults were set up for you, but now that you are a customer you will want to make sure they align with your business. Accessing your Account Summary Page To access these settings, the first thing you will want to do is open your Account Summary page. This page is your command central as an admin and you will be able to find settings and reports that will be vital for keeping track of your account. Tip: We recommend bookmarking this page if you are going to be a primary admin for your account so you can find it easily. You can use one of the following options to access your Account Summary page: From the global navigation menu (aka waffle icon), select Admin Console. In the Account Admin section on the My Apps page, click Manage my account. From the My Apps page, click Quickbase Admin, then Manage my account If you are a realm admin as well as an account admin, the drop down under Quickbase Admin reads Manage the realm. It takes you to the admin console, but you need to then click Account Summary to navigate to the Account Summary page. Now that you are on your account summary page, you can see your account’s current set up for Account Name, time zone, and formatting in the center of the page. If any of these options need to be adjusted you can do so in your Account Properties page by selecting the More drop-down menu at the top right of the page and selecting Edit Account Properties. You can learn more about your Account Summary page here. Setting up your Account Properties On this page, you will be able to choose several important options for your account including your Account Name, Billing Contact email address, time zone, and formatting. You can also find our terms of service if you ever need to review them. Account Name – This field lets you set the name your account should be under. Typically, this is either your organization’s name or the name of the group in your organization using Quickbase. Billing Contact Email Address - This could be the billing department of your org or a team member who is taking care of monitoring your bill and storing your invoices. This field is only used to set up who receives your invoice, it does not provide this email address with any admin permissions for your account. (The Account Permissions section below will cover how to add this user as a Billing Admin if they need admin abilities) Time Zone - Choose the time zone that will be used to display dates and times for all apps owned by the account unless an app is set with a custom time zone. Formatting Defaults - Choose the currency symbol, position, number format, and date format to be used across all apps owned by the account by default. Renaming your Realm You many notice that the URL for your account may not be what you'd like it to be. The default is often the name of the individual who opened the trial, a hyphen, and 4 trailing numbers. If it is important to you that your URL be on brand for your organization this can be accomplished by opening a simple support ticket to change you account URL. They will ask you to review a list of possible concerns to address before making the change. If your account is still young it's unlikely that you'll run into any, but they will want to make sure all the same. Here's the help topic on changing your realm's URL. Your Account Permissions From your Account Summary page, you can find a section labeled Permissions in the menu bar to the left. This page is where you can set up users who should have admin permissions in your Quickbase account and decide on several important default permissions. Reviewing and updating your Billing Account Admin One of the most important roles in your account is going to be your Account Admins. These admins can manage your account’s users, security settings, account level permissions settings, and billing changes. To set up your admins, head to the section labeled Permitted users and groups. You will be given a list of all of your current users or groups with specific permissions. From this list you can edit their admin or special permissions here. If you don't see the person, you are looking for you can click the Add user, group, or email domain group button and, in the User Picker that appears select the users or groups that need to be added to the list. Once you find the user(s) you would like to edit, you can do so by: Setting Manage Account permissions to Full Management or Support for the user you're granting administrative rights or No to remove access their account admin rights. Select Support-level if you want to let this person manage most aspects of your account, but do NOT want them to be able to change your billing plan or control administrative access permissions (like the ability to create and control the powers of other administrators as discussed in this topic). Select Full Management if you want to grant the person ALL administrative rights. Doing so gives the user all the abilities and power you have as the Billing Account Administrator. This includes the ability to control your access rights and any other account-level permission settings. Select No if this user should not be an account admin but should be granted other account-level permissions like access to app creation or pipelines. When you make changes, they are saved immediately. Tip: We recommend having at least 2 Full Management Admins on your account to help cover for vacations, leave, or changes to your team without interruption as only full management account admins can access number of important account settings and make billing changes. Setting Default Permissions for your Users On your Permissions page you can also set up default permissions for all of your users that impact who can build apps, create automated workflows known as pipelines, and use features such as plugins and user tokens. Allowing all users to create apps and pipelines allows you to source ideas and new apps from more of your team, while restricting access to specific users will give you more control over who can create apps and workflows in your account. Tip: When thinking about these permissions we recommend you look at your organization’s policies for tools and have a chat with your IT team on how they like to set up permissions. If you decide to set any of these permissions to specific users, you will want to use the same steps you used to add in a new account admin above but instead configure that account to only have access to the capabilities you want them to have. For example, below you can see Evan has the permissions needed to Create apps but not to create pipelines while Kyle cannot create new apps but can create pipelines. You can access the settings listed above at any time using these steps but setting them up to align to your team’s needs early will make moving on to building apps and managing your account much easier. Further Resources Account Summary Help Page Admin Console E-Learning On Demand Understanding Quickbase Admins Adding a Billing Account Administrator Download the Admin Account Checklist
Display Summary Table in Related Child Records
How can I display a parent summary table report in each child record? The report, screenshot below, includes all subprojects (the child records) related to a project site (the parent). I desire this report in the child table to display the related subprojects.September 2025 Qrew Meetup Recap
Thank you to everyone who joined yesterday’s Pipelines Qrew meetup. Here’s what we discussed: Rob Mersereau, Sr. Implementation Consultant, shared an encore of his Empower 2025 talk using a Mardi Gras example to show how to integrate Quickbase with Google Calendar through Pipelines. He noted that this use case can be applied to Outlook and SharePoint. Key highlights and tips: Link to app for following along Connect & Import: Rob demonstrated linking multiple Google accounts to Pipelines to pull Mardi Gras parade events into Quickbase—one record per event. Qrew Tip: Name Quickbase fields clearly with “gcal_” prefixes so AI auto-mapping works smoothly. Push to Calendar: He showed sending Quickbase parade plans to Google Calendar, writing back event IDs and clickable links for seamless updates. Qrew Tip: Always double-check your pipeline is turned on—this is the top cause of sync issues. Keep Data Fresh: Rob recommends using Bulk Record Upsert in Quickbase to quickly update or add records and track changes. Qrew Tip: Use Google event IDs as merge fields to prevent duplicates and enable reliable two-way sync. Build Gradually: Start with simple one-way flows, then add Teams alerts, Maps API calls, or multi-way sync as your workflow grows. Missed the meetup? Here’s the recording Attached is the participant guide to follow Rob’s examples. October is EmpowerPro month! Be sure to register for EmpowerPro October 7-8. Afterward, the Qrew will host a 3-part series, EmpowerPro Product Talks, on October 22, 23, and 28. More details coming soon!
