Table of Contents

How to Show Multiple Fields in Your Connection Drop-Down

Lesley Updated by Lesley

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 tables, fields, pages, and views. You can start by reading our Builder Basics section

Other good resources can be found in our About Your Database and Working With Pages sections of the knowledge base.

Steps

Add a Text Formula Field to Your Table

From the Data section of your Builder, select the table 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 table 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