Lookups need to be set separately in the Table Builder and Form Builder using the Lookup Wizard. In the Table Builder, you can use a lookup to display coherent data values in columns in place of IDs or codes. In the Form Builder, fields with lookups set up are transformed into dropdown fields where you can select appropriate values.
Setting up Lookups #
1. Run & Build your app and open the Table Builder or Form Builder by clicking on the icon.
2. Navigate to the Columns tab and select the column you want to add lookups to. Click on the icon to expand the column and show more column options.
3. Click on Lookup to expand the option. A button to start the Lookup Wizard will appear.
The Lookup Wizard #
Click on the Start Lookup Wizard button to show a guided step-by-step on setting up your lookup column.
- Select Database – Select the database where your lookup table is located.
- Select Table – Select your lookup table.
- Select lookup column – Select the lookup column that corresponds to the selected column in your current table.
- Select lookup column values – Select which column contains the column value you wish to display. You can choose more than one column for column values. A column delimiter field allows you to add any symbol to serve as a value separator.
- Lookup conditions (optional) –
- Default WHERE clause – You can add a Default WHERE clause if you wish to apply the lookup on specific values only. You can leave this field empty if no conditions are needed.
- Dynamic Conditions – In the Form Builder and if inline editing is enabled for columns in the Table Builder, you can update the lookup of another field based on the conditions set here.
- Load full lookup on startup – Enabling this option helps lookup entries load faster when users interact with your app.