Resource Icons
Latest Highlights
Check Out The Latest in The Qrew
We’re excited to share that as of April 21, the new forms experience in Quickbase is now generally available on mobile! This launch marks a significant milestone in our mission to provide a seamless,...
PolinaQuickbase
Quickbase Staff
2 MIN READ
Quickbase Admin Getting Started Guide
If you're new to being a Quickbase admin, start here! While it may feel like there is a ton to learn, the Getting Started Hub has you covered. This is how...
ben_simon
Community Manager
May is blooming with Quickbase events to help you grow your skills and connections! Our meetups, webinars, and community gatherings offer fresh opportunities to build and grow your knowledge of using...
EstherLaVielle
Moderator
The Content Feed
Feed
Parent to Child Reference Field
When making relationships between parent and children records I understand how to add additional lookups. But when you do that then those fields need to be "updated" when adding a new child. What I am seeking is a way that when a child record is created, and related to a specific parent, that the child record would show the value of additional fields from the parent. Example: Parent record has Name, Address, Phone Number, Favorite Color Child record has Child name, lookup field to select parent which would bring down the Parent Name and Favorite Color Currently when setting the relationship I would connect on Related Parent then add the lookups for Parent Name and Favorite Color, but when actually creating the new Child record once I select the related parent, the Parent Name and Favorite Color are not populating. If I want those to display the value, I have to manually update those fields (thus not benefiting from setting the relationship to the Parent). What am I missing? This seems like an easy ask but for the life of me I'm just not seeing a pathway to make this work.Solved0likes2CommentsHow to Calculate Completion Percentage Using Multi-Select Boxes
I’m trying to create a formula that calculates the completion percentage based on a series of multi-select checkboxes. For example, if there are four checkboxes and three of them are selected, I’d like the formula to return 75%. Is there a way to achieve this in Quickbase? Any help would be greatly appreciated! Thank you in advance!Solved0likes5CommentsPrimary and Secondary Contacts from Table
I'm pretty sure this is a simple many-to-many relationship, but my brain hitting a wall and cannot comprehend how to set this up. We have an app in development where employees can submit reports of things happening in their day to day. Each report is then "assigned" to a person or department from a Responder table to follow up. I most cases, each report will only have one Responder so I have a normal one to many relationship set up currently. Now, occasionally, we have a situation where there will be a Primary Responder, but another department/s or person/people are included for line of sight/further conversation, ie Secondary Responder/s. I would like to have two fields, one for primary and one for secondary so I can differentiate between the two when the Pipeline kicks out the email to everyone. Is this a simple many-to-many relationship or is this going to be a bit more complex? Thank you!Solved0likes2CommentsCan I have 1500 or more fields in one form in one table, spread across multiple pages?
I will be creating a new app. In one table, is it possible to have a form with around 50 pages, and each page would have anywhere from approx 10 to 50 fields (probably only a few pages would have 30-50 fields, most pages would have 10-20). Therefore, the total number of fields in the form would be anywhere from approx 1,000 to 2,500. Of that total, around 200 fields would be derived fields (formulas). I would also like to have form rules that hide certain pages based on a field selection. NOTE: for each record, only about 60-100 fields would be populated. Are there limits that would prevent me from adding that many fields? Or could so many fields cause performance or other issues, like problems with form rules functioning properly? While it is possible for us to pull out most fields into other tables and connect to the main table using relationships, for our users ease of use and ease of reporting, we are hoping to contain all fields in one form in one table.Solved0likes4CommentsDuplicate Record Checker
Hello, I have a form with two fields named "Year" and "Quarter". The Quarter field is a dropdown with options such as "Q1", "Q2", etc. The Year field is a numeric field where users enter a year (i.e., 2025). What I need help with is displaying a error message when users have duplicate Quarters for a single given year. Example: If a user has a record with "Q1" for the Quarter and "2025" for the Year, they cannot enter another record for 2025 with Q1. They may only select "Q2", "Q3" or so on for 2025. Hopefully I explained this well enoguh for someone to understand. If I can elaborate more, please let me know.Solved0likes5CommentsUsing pipelines to log the date/time including the seconds of a record change
I have a pipeline that logs when a record was changed in a tracker table. I need the date/time of the change to be accurate to the second. I can't have a pipeline copy the Date Modified of the source record to a Date/Time field in the status change record as we would lose the seconds. I can't use the Date Created of the record created by the pipeline as this and the user's action are offset by a second or two. I need this to be when the user made the change, not when the pipeline created the record. I created a Formula - Date/Time field in the source table that is ToUnixTime([Date Modified]), then the pipeline copies that to a Number field in the status change record. This works, however I'm in search of a more elegant solution than creating a formula field in every table that needs this. Is there a Jinja expression that will give me the ToUnixTime() of Date Modified without having to create a formula field?Solved0likes1CommentNeed help deciding between two db setups
I am pretty new to qb and am currently trying to create an app to help my department track a student's requested thesis committee. The (hopeful) process: student will submit form with their identifying info, proposed thesis title, then choose their requested thesis supervisor, and selected reader, both fields pull from the same list of faculty (though if someone is chosen in one field they will not appear in list in 2nd field - that's for another time to figure out). So in trying to build something I came up with two different setups and am wondering which people think would be best. Which do you think will be better longterm. Attached are screenshots of both relationship diagrams. Hopefully they are decipherable.Solved0likes8CommentsHelp with Lookup Fields from Multiple Parent Tables in Quickbase Form
Hello, I have a Quickbase app where a single child table is connected to three separate parent tables. Each parent table represents a different employee group, and the child table is set up to pull employee information from all three. In the form for the child table, I want to be able to look up and select employees from any of the three parent tables. However, I can only select from the first parent table I connected—its lookup field is active. The lookup fields for the other two parent tables appear grayed out and are not selectable, even though they are all connected in the same way, using the employee name as a lookup field. As shown in the screenshot, only the first table’s name field is selectable, while the others are disabled. What might be causing this behavior, and how can I make all three lookup fields usable in the form? Thank you!Solved0likes3CommentsCant See Associated Records
Hi i table 1 app - 3 tables, table 1, table 2, table 3 now i have relation of one to many from table 1 to table 3. this relationship is old and has been working fine but suddenly i cant see the associated records from table 3 at the end of the record in table 1. they use to populate properly earlier. i have not changed anything in the relationship, cant understand why getting this error, it says " sorry...error retreiving data Attached the image as well. Only thing i can think of is another admin, was asked to delete all the unwanted reports so he may have deleted the associated report from table 3. if yes, how can i recreate the same. ? or any other reason for this problem.Solved0likes5Comments