Active Table Editor Forms Designer

Once logged in as an Administrator, you can customise the Record and Table/Record layouts by modifying existing objects or adding and deleting objects as required.

Form Designer

Designer Screen Overview

Important: Property value is saved when the user press enter or click on different object property for example width

Working with combo box

Fixed combo box

Th above works well with static list of values.

Set field name
Populate values list
Populate items list
Leave filter and LookupId blank

Dynamic combo box

Th above loads list of values from the database (It uses menu item data).

Set field name
Set LookupId to menu item id you want to load the data from
Leave filter blank

Note: When menu item has only one field it is used to populate both list of values and list of items, when menu item has more than one field the first field is used to populate list of values ans the second list of items

Data example (single field)

Value/Item
London
Leeds
Paris
Brest

Data example (two fields)

Value	Item
1	London
2	Leeds
3	Paris
4	Brest

Dynamic combo box with filter

The above loads list of values from the database and applies filter to the list automatically.

Set field name
Set LookupId to menu item id you want to load the data from
Set filter to FilterKey=‘FilterField’ (Adjust FilterField accordingly)

Note: Menu item must have minimum 3 fields, the first field is used to populate list of values, the second list of items and the third field is used for the filter

Data example

Value	Item	Filter
1	London	1
2	Leeds	1
3	Paris	2
4	Brest	2

Video Tutorial

We have more videos on ETL-Tools.com YouTube Channel, Please take a look and subscribe to stay updated with the latest content.