Quick Base Relationships save time, reduce data entry errors, and summarize key information. Almost every Quick Base app has one or more relationships. But how do relationships help your team be more efficient, informed, and productive? And how do you create a relationship?
Deciding up-front what you want from your Quick Base relationship can make the process smoother. A few questions you may want to consider are:
If you’re familiar with our video series you already know Sally. Sally manages a large team that includes sales, marketing, and order fulfillment. Her sales reps enter contact information in a Contacts table. She also has information on all her customers in a Customers table. She wants to link these tables together so that she can:
She also wants to:
We’ll use Sally’s example for this blog post and go through how to create a relationship as well as creating a lookup field and a summary field.
Drawing a map of the relationships in your app can be a great starting point. This map doesn’t have to be fancy. You can use charting software, a white board, or even a cocktail napkin.
To link tables together, create a new relationship:
Step 1. Click the Customers table and then click SETTINGS.
Step 2. Go to Table-to-table relationships and click +New.
Step 3. In this example, we’ll select the Contacts table from the dropdown list and click Next.
Step 4. Choose how the tables relate to each other. The sentences are your clues. In this case, “Each customer may have many Contacts,” so select that option.
Step 5. Click Next.
This makes the Customers table the “Master Table.” Quick Base automatically adds an Add Contact button to the Customers form and displays a report of contacts.
The Contacts Table is the “Details Table.” Quick Base automatically creates a lookup field for the Customer Name. This lookup field creates a dropdown list Sally’s team can use to select a customer name when adding a new Contact.
In a one to many relationship, the Master table is the one and the Details table is the many.
Lookup fields enable you to bring in information from a field in another table. A Lookup field for Customer Name was created automatically when we created the relationship. To also bring in the customer’s address and phone, create two new lookup fields:
Step 1. Under the Customer Name Lookup field, select Address from the dropdown list.
Step 2. Underneath that, select Main Phone.
Lookup fields display in the fields list with double arrows next to the field name.
The relationship is the only place you can add lookup fields. To add more lookup fields later, come back here.
Summary fields enable you to summarize key information from a related table. In our example, Sally wants to summarize the total number of contacts for each customer. To do this:
Step 1.Click the Customer to Contacts relationship.
Step 2. Click the Add Summary Field button to add a summary field to the Customers table that displays the total number of contacts for that customer.
This new relationship, two new lookup fields, and a summary field enable you to:
You can even view a map of relationships in an app by clicking SETTINGS, App Management, and then clicking Show Relationship Diagram.
Do you have any tips we didn’t mention? Share in the comments!