Table of Contents

How to Show Multiple Fields in Your Connection Drop-Down

Danielle Kellogg Updated by Danielle Kellogg

Scenario

You need more information (or multiple fields) included in your connection field drop-down.

Requirements

If this your first time creating an app, you'll need to know some basics about adding objects, fields, pages, and views. You can start by reading our Builder Basics section

Other good resources can be found in our designing the database and building pages sections of the knowledge base.

Steps

Add a Text Formula Field to Your Object

From the Schema section of your Builder, select the object where you want to display multiple fields in your drop-down. Add a new text formula field, we’ll call ours Product Name.

Once you’ve named your new text formula, select each field you want to include, adding symbols or characters between them as desired. In this Purchase Order example, we’ll add Part No - Manufacturer - Description, then click "Add Field" to save it.

You can read more about using text formula fields here.

Set Display Field to Show Contents of the Text Formula

Select the object in which you created your text formula field. Then click on the Settings tab:

In the Settings tab, you’ll see a drop-down titled "Display Field." Click here and select the name of the text formula field you just created (in our example, this field is called “Product Name”):

Click "Update Settings" and open your app to test the new drop-down. It should display the text formula you created -- a combination of the fields you added. In our example, Part No - Manufacturer - Description are displayed:

Notes

You may need to allow your records to update, as this text formula field works like an equation, and will need to query your data to update records based on the new formula.

How did we do?

Showing Parent-Child Records in the Live App

Contact