Quickbase Discussions
A forum for Qrew members of all levels, where questions about Quickbase can be asked and answered.
Links Banner
Main Content
Recent Content
URL for current time in Time of Day field
Hey all, Trying to deal with stamping a Time of Day field with the current time when clicking a button. I know about how "now" functions to do this properly when using a Date/Time field, but it doesn't seem to translate properly into Time of Day fields. It errors if I just try to use "now" in the field assignment and returns nothing if I ToTimeofDay("now"). I can't use Now() because this caches the time the page loads and that won't work for how this process needs to function. What's my best option to get this handled?
Numeric Fields Show Separator After 4 Places
Curious to get other's thoughts. We have not enabled the new Grid Reports in our primary application. We have one application used by a small group that does have new Grid Reports enabled. This application (with Grid Reports enabled) has summarized data from our primary application. I was updating the data today and noticed the totals have the comma separator after 4 places. So, 100000 is displayed as 10,0000. When last updated, I'm pretty sure the comma separator was after 3 places. I see in the field properties a select of Show separator after 4 places or Show separator after 3 places. This appears to be a new option with the default of 4 places. For all the numeric fields, I'll need to manually change to 3 places. I could not find anything in the release notes about this option. Has anyone seen anything related to this? Is there any way to change the default to 3 places? I have a feeling this is going to be overlooked quite a bit when adding new numeric fields.How to Sort Specific Options in Drop Down List
Hey everyone, is it possible to sort 7 or 8 specific records to the top of a drop down list? For context, there are 120 records in this drop down list, so they don't all show due to drop down list length limitations. They have to be searched for. However, I'd like to have the most commonly selected options put at the top of the list for quick selection without searching, but I can't change the naming scheme of the items for reporting purposes to do it the easy way. The drop down list is pulled from a relationship, not manual entry of all 120 items for the list. To summarize, this is for utility poles. They all have their own class, species, and size. All of the pole info is in its own table. I used the concatenate formula to combine all 3 details (size/class/species) into one field for the delivery table, so the employees can pick the pole the delivered that day. I just want the commonly delivered poles shown at the top of this list. Is this possible? The built-in AI says no, so I thought I'd give this a shot. Thank you!Form requirement nuanced trade-offs with proper relational structures
I have two related questions! Someone suggested using grid edit reports on my forms for a more all-in-one parent-child editable comprehensive form. That's not working at least on my end -- has anyone had grid reports be available within a form? I'm reorganizing another section of my app for a division that hasn't moved over to my current setup yet. In their legacy setup, there is currently a one-form-fits-all, which requires many things based upon the service level they rendered. We're moving to a "Clients", "Cases", and "Service Calls" -- which means I no longer can require things at the Client or Case level based upon the extent of the service call..... is this just a trade off I have to make? I'm concerned people might not go back into the parent record and update with additional information as it's received in this new setup (and hence why the grid edit would honestly be a fabulous option -- bring the Service Call record right onto the master record and edit it all from there).Pipeline Filters using AND and OR
I have a pipeline which has a search step from a list of students. In the filter I want to include the names I want and not the entire list. SchoolName is xxx AND Student Name contains John OR Student name contains Michael OR Student Name contains Joan OR .......they are 24 how can I approach this using using advance filtersApp Builder Qrew June 2026 Breakout Session Recap
Hello Qrew! Thank you to everyone who joined the App Builder Qrew meetup breakout session focused on QB Intelligence on Tuesday June 16th. Here’s what we discussed: AI Agents for Formulas — James Travaglini: James showed how AI can help builders create and refine Quickbase formulas faster, including examples like generating visual progress indicators and validating formula logic directly in Quickbase. Claude + QB Intelligence Prompts — Josh Miller: Josh shared how Claude can help turn business requirements into clear QB Intelligence prompts. He demonstrated how to structure prompts for tables, fields, relationships, and app validation so builders can move from idea to app structure more efficiently. Let me know if you need the skill file Josh mentioned and I will send it to you. AI Actions Use Cases — Jacob Buslewicz: Jacob walked through simple workflow examples using AI Actions, including how AI can extract key details from attachments like invoices and use that information to update or create Quickbase records. Unfortunately, we didn’t get a good recording of his session, but we do have an example of one of his use cases walking through in the recording. Missed the meeting? Here’s the recording of all three sessions Qrew tips: QB Intelligence can help reduce time spent on formula creation, app planning, and workflow setup. Strong prompts and clear requirements are essential to getting better AI outputs. Thanks again to James, Josh, and Jacob for sharing their examples and insights, and to everyone who participated in the breakout discussions. The next breakout sessions on QB Intelligence for Realm Admins will take place Tuesday June 23 rd at 12pm-1:30pm EST. James and Josh will be back to share use cases forQBI control center and QBI analysis + Claude to create a realm cleanup plan. Joining them is Georgi Georgiev who will share why the product team designed Quickbase Intelligence, how it works, and its governance capabilities. Come ready to learn, ask questions, and have fun moving from room to room. Be sure to register here. Thank you and hope you can join us next week!Quickbase Developer - Full-Time
We are looking to hire a full-time Quickbase Developer and Integration Specialist. If you feel like you would be a good fit, please apply at the link below. Position Type: Remote | Hours: Eastern Time Business Hours | Reports To: CEO / Operations About Glass Design Glass Design is a family-owned, second-generation designer glass and door company serving Southwest Florida since 1996. We specialize in custom and designer exterior and interior glass and door products, providing retail, manufacturing, and installation services to both residential and commercial clients. We are a team-led, learning organization that runs on EOS. We work hard, have fun, and live by our values every day. Our passion is simple: To Deliver Exceptional Employee and Customer Experiences. Our Core Values We Choose Optimism ... we lead with a positive mindset and believe in what is possible. We Embrace Continuous Learning ... we are always growing, improving, and seeking new knowledge. We Relentlessly Pursue Improvement ... good enough is never the finish line. We Get Sh!t Done ... we take ownership, follow through, and deliver results. We Do the Right Thing ... integrity is non-negotiable, always. Position Overview We are seeking a skilled and proactive Quickbase Developer and Integration Specialist to join our remote team. This individual will own the development, maintenance, and continuous improvement of our Quickbase applications and automation workflows. The ideal candidate brings deep, hands-on Quickbase platform experience, strong problem-solving instincts, and the communication skills to collaborate closely with our internal team during U.S. Eastern Time business hours. Key Responsibilities Quickbase Development Design, build, and maintain custom Quickbase applications tailored to business operations including project management, quoting, scheduling, and workflow tracking. Improve forms, fields, workflows, and automations to support evolving business needs. Build and maintain reports and dashboards that give leadership and staff clear visibility into operations. Develop functionality using Quickbase formulas, Pipelines, and scripting. Troubleshoot issues and continuously improve existing processes and application logic. Create simple documentation or training materials as needed to support team adoption. Integrations and Automation Set up and manage integrations with tools such as Zapier, FastFields, CallRail, and RingCentral. Build, maintain, and optimize multi-step Zapier workflows that connect Quickbase with other platforms. Monitor active integrations for errors or failures and resolve issues proactively. Identify new automation opportunities across the business and design solutions that reduce manual work. Maintain clear documentation of all active integrations, trigger logic, and connected applications. Collaboration and Communication Participate in regular check-ins and project updates with leadership and staff during ET business hours. Communicate clearly and proactively about project status, timelines, blockers, and recommendations. Translate non-technical business needs into functional technical solutions with minimal back-and-forth. Provide guidance to internal team members on using Quickbase applications or automated workflows. What We Are Looking For Experience building and managing Quickbase apps with a strong understanding of Pipelines, formulas, roles, and permissions. Minimum 3 or more years of hands-on Quickbase development experience, with a portfolio of real-world applications. Familiarity with integrations using Zapier and other APIs. Bonus: JavaScript experience or familiarity with webhooks and REST APIs. Self-starter who can work independently on flexible, project-based tasks. Fluent English communication skills, both written and verbal, with the ability to clearly explain technical concepts to a non-technical audience. Must be available and responsive during U.S. Eastern Time business hours (Monday through Friday, approximately 8:00 AM to 5:00 PM ET). Excellent responsiveness, follow-through, and attention to detail in all communications. What We Offer A stable, long-term remote role with a family-owned company in business since 1996. A collaborative, values-driven team environment where your contributions are visible and valued. Consistent work managing and growing a meaningful tech stack for an established specialty business. Opportunities to take ownership of projects and make a real operational impact. How to Apply Please submit application HERE - APPLICATION
Project Status Spotlights
Hi, I am using a Project Status multiple choice dropdown field with the following options: Green - On Track Yellow - At Risk Red - Off Track Blue - Complete Purple - On Hold Black - Canceled Silver - Closed I'd like to incorporate the Project Spotlight formula featured in Exchange so that the status displays in it corresponding color (while also keeping the text separate). I'm struggling with where to insert the formula and how to modify the formula to recognize my custom status values and colors noted above. I appreciate the help!Accessing previous field values after an import mapping failure
I have a bulk event-triggered pipeline firing whenever records are modified, leading to an Import to Quickbase step. The import stores current and previous field values on another table. Working on error handling for this import, I would like to log the attributes of the intended "change record" it was attempting to create, i.e. current and previous field values of the source record. If the error was an "import error" this is easy: I can access any of the target field values inside the `import_error.record` container. But if the error was a "mapping error" then it seems only the source's current fields are accessible through the `mapping_error.item` container, with apparently no metadata like previous field values. I don't think I can reference the original record in this context because it's a completely different object with a different index (since the import failures are obviously a subset of the original record set). So this leaves me without a way to store previous field values if there is a mapping error that I can see, unless I restructure the pipeline to process the records serially, which I'd prefer not to do if I can avoid it as the trigger event can potentially be quite large (thousands of changes at a time). Am I missing something? Or should I just not concern myself with auto-handling mapping errors in production, because the data types should never be allowed to change in the first place? Should I just make sure to throw a bright red alert if it does ever happen?
QuickBase Reports Help
Hi all, new to QuickBase but not new to database tools. I'm trying to build a specific report within QuickBase. In Tableau it's called a Bowling Sheet. A non-propriety example looks like this: https://www.allaboutlean.com/wp-content/uploads/2025/01/Bowler-Chart-Example3.png Ive been able to get sort of close in QuickBase by using the Summary Report, and I can group columns by Month to achieve the same result, but my issue is that it's giving me a COUNT of the data that's being reported instead of the actual value of that data. I'm sure it's something stupid/easy that I'm overlooking, but I'm stumped. Any help would be appreciated.
