Table Lookup

Table Lookup Icon

Lookup control enables data in populated fields taken from tables and other user defined data types to be searched and filtered. When filling out this field, users will select from the referenced data source and any dependent fields will then be automatically filled with the matching data set.

This page describes the settings that are characteristic of the Table Lookup component. Please find the general settings here:

General Settings

These settings can also be used to customize the standard Submit button that is automatically added to an eForm.

Info Icon

Note:

Lookup control should be configured after all the other required fields in the form as these can be used as dependent fields.

Data Tab

Therefore™ Referenced Table
Select one of the Referenced Tables.

Note Icon

Note: Table Lookup in Anonymous Eforms

When configuring a lookup in an Anonymous eForm please be aware that the data in the table will be publically available to anyone accessing the form.

Do not use table lookups containing sensitive or confidential data in Anonymous eForms.

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 drop-down menu. Then, choose a form field from the drop-down menu under Form component to map the referenced table column to.

Filter

Select which field to filter the results of the table lookup by. When a user opens the table lookup, they will be able to filter results by entering values for the selected field.

Only the following types of fields can be used to filter for results:

  • Currency

  • E-mail

  • Number

  • Text field

Size
Define the width of the table columns. Choose a value from 0-16 from the drop-down 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
Info Icon

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:

  • not using “Relative Sizing” and the referenced table has 10 or more columns or

  • “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.

Remember value for subsequent visits
Stores the Default Value for future reference.

Layout Tab

HTML Attributes
Provide a map of HTML attributes for the component's input element.

Attribute Name
Name the HTML attribute.

Attribute Value
Add a value for the HTML attribute.

Delete HTML attribute
Click this button to delete the respective HTML attribute.

Add Attribute
Click this button to add a new HTML attribute.