This section is still being updated. Some information might be incomplete. If you have any questions, feel free to drop us a message here.
Lookups are now available to all app types and need to be set separately in the Table Builder and Form Builder.
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.
![Table Builder Table Builder](https://cdn.statically.io/img/wpdataaccess.com/wp-content/uploads/2024/06/lw-1.png)
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.
![Column Options Column Options](https://cdn.statically.io/img/wpdataaccess.com/wp-content/uploads/2024/06/lw-2.png)
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.
![Lookup Wizard Lookup Wizard](https://cdn.statically.io/img/wpdataaccess.com/wp-content/uploads/2024/06/msedge_bYQxIzqGjd.png)
- 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.
Updating Lookups #
To update a lookup, simply click on the Update button. This will let you go through the steps again from the start.
Deleting Lookups #
To delete a lookup, click on the Delete button. A prompt will display to let you confirm the action. You need to click on APPLY for the deletion to take effect and then click OK.