Skip to main content
All CollectionsTemplates
Auto-fill multiple fields with a single field response using a database formula
Auto-fill multiple fields with a single field response using a database formula

Learn how to use a Form User’s selection in one field to automatically populate multiple fields with your Account User List.

Updated over a week ago

❔Catch-up quick

Your Account User List is unique DataSource which references attributes from the user profiles in your account.

Unlike other DataSources, which you create and manage with third-party apps, your Account User List does not exist as an available resource in your account. Instead, information is edited within each individual’s user profile.

The database formula you’ll write in this article will populate user attributes based on the Form User selecting their email address when they fill out a Form.

Populate multiple fields based on a Form User’s response in a single field when you leverage your Account User List in a database formula.

Select one user attribute to act as the driving database field. You’ll then relate this field to additional fields. Your Form User’s selection from the driving database field determines the information that populates in the related fields.

🗒️ Note: Your driving database field's display column must be either User email, or Key.

To drive each related database field, you’ll add a formula to each related field’s default value property. In this example, database fields are used for the related fields, but you can also reference text fields in your database formula.

In the formula. . .

=Database(”Account User List”,[UserEmail],”Full Name”)

  • =Database references the database Template function - not a database field.
    ​

  • “Account User List” indicates the referenced database.
    ​

  • [UserEmail] indicates the driving database field.
    ​

  • “Full Name” references the information you want to pull from your selected database for your related field.

🗒️ Note: If you want to include multiple related fields, you’ll need to repeat steps number 4-7 for each related field.

When you repeat these steps, substitute Full Name with your desired user attributes.

In the web app, open your Template in the Template Editor and complete the following steps.

  1. Add a database field to your Template to act as your driving database field.
    ​
    ​

    Screenshot displaying the location of the "database field" in the Template Editor within the web app.


    Enter a name for your field.
    In this example, the field is named “UserEmail”.
    ​

  2. In the Properties panel, locate and access DataSources.
    Select Account User List.
    ​
    ​

    Screenshot displaying the location of the Account User List in the database field's DataSources field property.


    ​

  3. Below the DataSources property, locate and access Display Column.
    Select User email.
    ​

    Screenshot displaying the database field's Display Column property open to display the location of the User email option.


    ​

  4. Add a database field to your Template to act as your related field.
    ​

  5. In the Properties panel, access DataSources.
    Select Account User List.
    ​

  6. Access the Display Column menu.
    Select the user attribute you want to pull in.
    ​
    In this example, “Full Name” is selected.
    ​

  7. Locate the Default Value property.
    Here, you’ll enter the following database function formula:
    ​
    ​ =Database(”Account User List”,[UserEmail],”Full Name”)

Next, you can. . .

  • Click Save Draft and then Preview to test your new functionality.
    ​

  • Edit your Template further.
    ​

  • Add more users to your account.

Did this answer your question?