Use Queries to populate data
· The user takes enter Query if the values to be entered are quite more and the user may find it difficult to enter each of them manually.
· List of values appears once the user wishes to add a particular value under a certain column.
Step 1: Define Query
· User can define the Query while defining the User Defined Table.
· Since we have already defined the table, we just edit it to enter the Query. Click on the Edit icon.
· Find the Generate option at the end of the Item row. Enter the Query that provides a list of Items when the user wishes to add any Item in the table. Save it.
· Save the changes in the Used Defined Tables.
· Since the Menu Design and User Authorization is already done. We directly check how Query works on UDF TABLE. Refer Example
· Clear Cache before adding Items in the UDF TABLE.
Step 2: Add Row/Data in User Defined Table
· Go to Menu Bar --> User Tables --> Sample Table Name. Click on Add icon to add some value under Item Column.
· Click on the search icon beside the item to see the list of Items.
· Select any Item among the list of Items.
· Other fields can also be filled and click Add.
· User can see newly added Items in the Table.