Thereforeā¢ Referenced Table
Select one of the Referenced Tables.
Max Rows
The maximum number of rows returned from the server.
Items per page
Define a default value for how many items should be displayed on a page. Choose an integer between 5 and 100.
Hide browse button
Hides the browse button making the popup window inaccessible.
Relative Sizing
Enable Relative Sizing to adjust the width of Referenced Table columns.
Hide Index Column in Results
Hides the index column in Table Lookup.
Referenced Table configuration
Configure the Referenced Table.
Table Column and Form component
Choose a column of the selected referenced table from the dropdown menu. Then, choose a form field from from the dropdown menu under Form component to map the referenced table column to.
Filter
Use a Filter for the Referenced Table. Please find a tutorial on using filters for Referenced Tables following the link below:
Tutorial: Referenced Table filters
|
Note (when ticking the Lookup checkbox): After defining the hidden fields for some of the look-ups as Trigger fields (i.e. you have the lookup checkbox on). This triggers a lookup to occur if that field is manually obtaining data from the user. As those fields are hidden and a user can never enter data here manually, it should be turned off/enabled.
|
Size
Define the width of the table columns. Choose a value from 0-16 from the dropdown menu. The sizes correspond to the following column widths:
0
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
0px
|
50px
|
100px
|
150px
|
200px
|
250px
|
300px
|
350px
|
400px
|
450px
|
500px
|
550px
|
600px
|
650px
|
700px
|
750px
|
800px
|
|
Note:
•The default size value is 2 (100px).
•The Table Lookup component is able to open in āwide modeā using 90% of the browserās width. This is triggered if one is
onot using āRelative Sizingā and the referenced table has 10 or more columns or
oāRelative Sizingā is enabled and the sum of the columns' width is 30 (1500px) or greater. |
|
Delete Referenced Table
Click this button to delete the respective referenced table.
|
|
Add Referenced Table
Add another referenced table for mapping.
|
Sort By
Sort by selected table column.
Default Value
This will be the value for this field, before user interaction. Having a default value will override the placeholder text.
Input Format
Select from Plain, HTML or Raw formats.
Refresh On
Refresh data when another field changes.
Clear Value On Refresh
When the Refresh on field is changed, clear this components value.
Remember value for subsequent visits
Stores the Default Value for future reference.
Allow Manual Override of Calculated Value
Will allow the user to manually override the Calculated Value.
|