Recent Content
View query record if single record otherwise view query list
I am creating some buttons in a Formula - Rich Text field. They will allow users to quickly jump from one table to the next using the table to table relationships we have set up. Mainly what they will be seeing is a list of related records based on a query. For example, if I am in the Customers Table and I click on the Invoices button it will take me to the invoices table and I can see all the invoices related to that customer. If there is only one invoice I would like the button to take me directly to that invoice record and not view it in list mode. Is there a way to use the query and set up an if statement that would check the length of the query response and if there is only one then view that record. Below is an example of the query code I am using for one of the buttons. URLRoot() & "db/" & [_DBID_INVOICES] & "?a=q&query=" & "{'6'.TV.'" & [Record ID#] & "'}"Upcoming Customer Events for Spring 2024
7 MIN READ Hey there Quickbase enthusiasts! 🌼 Can you believeit's already March? Time sure does fly when you're having fun (and building awesome things with Quickbase, of course)! As we gear up for spring and all the exciting things it brings, we've got a lineup of events that will make your March and April even more fantastic. So grab your favorite beverage, get comfy, and dive into what's coming your way! Below is a list of our upcoming events with registration links and agendas. For an up-to-date list of what else may be coming, check out www.quickbase.com/events. MARCH Mobile Workflow – March 20th Customer Network Join the Mobile Workflow Customer Network meeting featuring Solutions Consultant Brian Tiu and Senior Product Marketing Manager Radhi Jagirdar. Learn to create, deploy, and analyze data using Quickbase and Fastfield together, and get a preview of what willbe next on the mobile product roadmap. AGC 2024 – San Diego – March 20th to 22nd Conference (In-Person) Come chat with our team at booth #114 to learn more about how Quickbase can modernize your operations in an industry where always-on is a must with automation and AI, and how it can be your centralized platform for real time insights. Dallas Fort WorthQrew Kickoff - March 20th Qrew Group (Virtual) Members of the DFW Qrew will be kicking off their Qrew Group with a virtual meetup. Come meet others in the DFW area who are using Quickbase, see an app from Soutwest Airlines, and win prizes! Houston Qrew Kickoff - March 22nd Qrew Group (In-Person) Members of the Houston Qrew will be meeting up to share tips and tricks on how to Quickbase. There will be live demos of apps, help with troubleshooting active issues, and more! Healthcare – March 27th Customer Network Jan Miotto and Megan Berroth from Metrendalytics will showcase a solution for data integration and systems validation using Quickbase as the information glue. If you are looking for an efficient workflow solution to integrate and validate systems data, you will not want to miss out this informative session. Boston Qrew Kickoff - March 27th Qrew Group (Virtual) Members of the Boston Qrew will be meeting up to share their Quickbase apps and discuss plans for an in-person gathering at Empower. Portland Qrew - March 27th Qrew Group (In-Person) Bring your laptop and join the Portland Qrew members at Harder Mechanical for their monthly meet-up to collaborate on application challenges and share innovative ideas and solutions SoCalQrew Meetup – March 27th Qrew Group (Virtual) The Quickbase Junkie, Sharon Faust, will be on hand to show some slick tips to the SoCal Qrew. Click the link above for more information and come join the fun! Aviation Qrew Meetup – March 28th Qrew Group (Virtual) Members of the Aviation Qrew will convene to show off some game-changing apps. Come see how Aviation industry customers are using Quickbase to solve real business problems. A Guide to Governance and Centers of Excellence Webinar – March 28th Webinar Join this webinar to learn theimportance of application governance, implementing best practices for governance policies, and how to empower employees to innovate securely with a flexible, no-code governance model managed by IT. Sweet Connections: The Scoop on Relationships - March 28th Semi-Private Training Indulge in our build-along workshop focused on the power of relationships! Learn how to optimize app relationships to improve app performance, data management, and user experience. Spy Analytics: Data Visualization with Reports and Dashboards - March 29th Semi-Private Training Join us on this mission to create dynamic dashboards, integrate cross-app reports, and enable role-based data visibility for the Quickbase Intelligence Agency. APRIL Galactic AppVenture: App Building for Beginners April 1st and 2nd Semi-Private Training Launch your app-building skills to infinity and beyond with our newest Quickbase Fundamentals course! Join the two-day course where you'll be guided through the fundamentals and best practices of building apps that are out-of-this-world efficient and effective. App Builders – April 2nd Customer Network Laura Linssen (JJ Keller) will be sharing a "before" and "after" of her forms. The forms and how they looked on the old forms and the great things she built when moving them to the new form experience. Joining her is Alice Rich, Sr. Product Manager, who will give the audience a preview of the "New Navigation"beta that will roll out soon and answer questions from the audience. Manufacturing – April 3rd Customer Network Anthony Offredi, Quickbase & Manufacturing Subject Matter Expert will be showcasing an app that can be used by customers to manage the Shop Floor Management System (SFMS). SFMS is the digital commandcenter from which all activities are related to the availability of people, productivity reporting, job skills training, and assignments. Galactic AppVenture: App Building for Beginners April 8th and 9th Semi-Private Training Launch your app-building skills to infinity and beyond with our newest Quickbase Fundamentals course! Join the two-day course where you'll be guided through the fundamentals and best practices of building apps that are out-of-this-world efficient and effective. Realm Admin – April 9th Customer Network Join our April meeting to see details for the upcoming first release of Solution API and discuss how this can solve application lifecycle management problems in your organization. Venti Tasev & Ryana Stoycheva from the Quickbase product team will be presenting. Feature Focus - April 11th Webinar Join Customer Success Managers Manny De La Cruz and Kiko Anzoategui as they take a look at our first quarter's feature releases and share their favorites so far in 2024. They will go over some of the most impactful enhancements and get the audience excited for what is to come at Empower 2024. Galactic AppVenture: App Building for Beginners April 15th-16th Semi-Private Training Launch your app-building skills to infinity and beyond with our newest Quickbase Fundamentals course! Join the two-day course where you'll be guided through the fundamentals and best practices of building apps that are out-of-this-world efficient and effective. World Congress Experience – April 16th to 18th Conference Meet up with us in Detroit at booth #335 where you can learn more about Quickbase’s most requested features. See how industry innovators are using one platform to see, connect, and control all their work. Architecture, Engineering and Construction (AEC) – April 16th Customer Network Agenda TBD – Let us know if there’s anything you’d like to hear about or if you’d like to present! Mobile Workflow – April 17th Customer Network Agenda TBD – Let us know if there’s anything you’d like to hear about or if you’d like to present! End-User Reporting: Quickbase made Easy - April 18th Semi-Private Training Plan, create, and customize reports tailored to your needs! Join us for this hands-on live training course to empower non-technical users to plan, create, and customize reports within Quickbase. Galactic AppVenture: App Building for Beginners April 22nd and 23rd Semi-Private Training Launch your app-building skills to infinity and beyond with our newest Quickbase Fundamentals course! Join the two-day course where you'll be guided through the fundamentals and best practices of building apps that are out-of-this-world efficient and effective. Education/Nonprofit - April 23rd Customer Network Allan Heaps from Boise State University will showcase how he is updating the class schedule app that is over 10 years old. This is an informative session for customers looking to see what it takes to update a large existing application on your own. Pipelines – April 24th Customer Network Melissa Freel, from Neighborhood Legal Service Michigan, willshare a solution that generates a HUD-requiredDocuSign form forbuilding inspectors via Pipelines for housing evaluations. Joining her is ourQuickbase Product team, Stasha Markovska and Edi Evstatiev, who will discuss the new App Field and share thedesign for the overview card. Galactic AppVenture: App Building for Beginners April 29th and 30th Semi-Private Training Launch your app-building skills to infinity and beyond with our newest Quickbase Fundamentals course! Join the two-day course where you'll be guided through the fundamentals and best practices of building apps that are out-of-this-world efficient and effective. Best Dressed: Styling Mastery of New Forms - April 29th Semi-Private Training Unlock the secret to sophisticated app styling, featuring our latest enhancements to new forms! Join this live training session if you are looking to streamline navigation, optimize layouts, or introduce dynamic elements within your applications. Form Fest: Data Validation with Dynamic Rules - April 30th Semi-Private Training Step right up to Forms Fest, a build-along workshop designed to sharpen your data validation skills! Sign up for this course to get your ticket to mastering the art of data validation, where you'll learn to craft dynamic rules that ensure data quality and enhance the flow of the user experience. MAY Empower 2024 – May 8th Interested in saving 20+ hours of admin work per week? Join Us at Empower 2024 and learn how Daifuku Intralogistics America, Lithko Contracting, Unipress, Valmet, and others are finding better ways to uncomplicate how they get work done. We can't wait to see you at these events and share some tips and tricks along the way. Stay tuned for more updates and exciting news from the CS@Scale team at Quickbase. Let's make this spring one to remember! 🌷 Keep building amazing things! Esther LaVielle, Customer Success
Justifications for Table Report Columns
Hey Everyone for some reason these two columns will not justify properly. One is Right of Center and the other is Left of center. When next to each other, it's hard to read. they both need to be next to each other as well. Is it possible to make them center, and to have it stay center? I can adjust it in the column properties. but it just resets the next time i load the report. please advise. ------------------------------ Jack Woods | Low Code 4 Lyfe ------------------------------
Quickbase JMP connection
Hello, I am trying to connect one of the Quickbase table to JMP statistical software to perform analysis. I want to able to connect a table to JMP which I can publish and refresh once I have published the reports. I do not know how to start. Does anyone has experience with this and can provide me some direction? Thank you. ------------------------------ Tapish Bij ------------------------------
Prefilter the related field
Parent Table is Associates - Child is Resets What I want to do is for the Related Associate field to lookup any associate that is only a manager. Currently it lists ALL associates. How can I go about "pre-filtering" my choices? ------------------------------ Hans Hamm ------------------------------How to associate a supervisor with an employee
I have inherited a Form and need to assign a certain supervisor to a list of employees into this form. I have 0 coding experience and do not know anything beyond the extremely basic bits of creating a form. I have the list of employees and list of supervisors as a text drop down but I would like to associate the employee's name with their supervisor to auto populate. How can I do this? Thank you for your patience and understanding! ------------------------------ Lua Vick ------------------------------
QuickBase and DocuSign
Hello, I am trying to see if QuickBase pipelines can help with a DocuSign issue. We have a Contract for Construction. Inside there is a checkbox for the signer to state if they are the property owner or not. If they are NOT the property owner, we would like to send out another document (Letter of Authorization) to the property owner using QuickBase pipelines. Is it possible to check for both the email of the owner and the checkbox status from the Contract for Construction, and use that to send out the Letter of Authorization? I see there are some connections to DocuSign but I don't quite understand how they work. Any help would be appreciated! ------------------------------ Cassandra Friend ------------------------------
ADDING REVENUE AND EXPENSES
hello all im new to this so far so good but cant seem to get anyone to help. I have a work order table that contains revenue, tech payout, new profit and percentage in revenue how do i go about doing this? Also on the other screen shot i want to preview the service line item from the work order page ------------------------------ Steven Lebron ------------------------------
