Lookups

An overview of how to create a lookup

A Lookup is a  element control/feature that can store a list of single columned values 

Example: Country lookup shall contain the list of Countries like India, Australia, UK, USA, etc .

                  Weekdays lookup shall contain a list of all the days in a week like Sunday, Monday, Tuesday,                      etc.

You can use a lookup to set a list of pre-defined values in a drop-down field while creating a form while creating an app. Learn about how to use look ups in a apps.

How to create a Lookup?

  • On Dashboard, click on the Admin Menu > Database > Lookups.

  • You will land on the Lookups List page.
  • Click on the Select Workspace drop-down, and select a Workspace.

  • Click on the Add Lookup button.

  • An Add Lookup pop-up will display on the screen.
  • Enter the lookup name and Save.

  • The lookup will be saved.

  •  Click on the Lookup, to add values in it.

  • You will land on the look up values page. Click on the + Add Lookup Value(s) button.

  • Add Lookup Value(s) pop-up will display on the screen, as shown below.

  • Add the values in the fields, as shown below.

  • Click on the Add button to add a new field to the list, as shown below.

  • Click on the Save button to save the values.

Note: You have an option to import the values into a look up from an excel as well.

How to import values into a look up?

  • On Add Lookup Value pop-up, select the Import Lookup Values option.

  • Add Lookup Value pop-up will show you Download and Upload Excel buttons.
  • Use the Download button to download an excel. Open the excel and upload single columned valued in the excel, as shown below.
  • Save the excel.

  • Use the Upload Excel button on the Add Lookup Value pop-up to upload the excel and import values into a look up.

  • The imported values would display on the Add Lookup Value pop-up.

  • Save the look up values.