Home / QIN / Knowledge Base / How do I create a dependency, so that when a user's name is selected to assign them to a task record, other fields in the form automatically populate with the user's email address and phone number?

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How do I create a dependency, so that when a user's name is selected to assign them to a task record, other fields in the form automatically populate with the user's email address and phone number?

In QuickBase we call what you refer to as a dependency, a relationship. A relationship always involves two tables.

In the example above one of the tables would be a table of users. The users table would have a field for email address and a field for phone number. The users table, in this relationship, is the master table.

The other table would be the tasks table. The tasks table, in this relationship, is the details table.

To learn more about relationships please read:
https://www.quickbase.com/help/about_relationships.html

Enhance this relationship with "lookup fields" Lookup fields draw additional values from the Master (users) intot eh details table. In this case, you'd just create lookup fields for the email address and phone number fields. (Read how to add lookup fields to a relationship here: https://www.quickbase.com/help/create_lookup_field.html)

Then when you add new task and select a user related master record), their email address and phone number automatically populates.

Tags:
  • 37982 reads

Comments

RE: 'Adding the phone number to user profiles'

Submitted by bcafferelli on Thu, 06/13/2013 - 19:02.

Hello,

 

While the user profile doesn't have a spot for a phone number, you can set up a table in your app for your users, and you can use fields to track more information about them. One of the fields on that table would need to be a user, which would tie it to the QB user profile.

 

Thanks,

Brian

Intuit QuickBase

Adding the phone number to user profiles

Submitted by Anonymous (not verified) on Tue, 05/21/2013 - 20:07.

What would be ideal is if we could add additional fields to the user profile, such as the phone number etc.  That way this information can be used to auto-populate fields in other tables.

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

Rate This

0
No votes yet
Your rating: None

© 1997-2013 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit