Show/Hide Toolbars

Therefore™ Help

Reference > Solution Designer > Design > eForms Object > eForms Components > Basic Components

Table Lookup

Scroll

SD_R_Design_eForms_Comp_TL_001a

The Lookup control enables data in populated fields from tables and other user defined datatypes to be searched and filtered. It is recommended to first add all required fields to the form and finally configure the lookup control; (i.e. to lookup customer data, first add fields for Name, Address, Contact, Country etc.) and finally configure/add the Lookup control. Any field type can be used as a dependent field (ie. Text, Date, Number etc).

 

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

Reference: General eForms settings

 

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

 

Data Tab

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 drop-down menu. Then, choose a form field from the drop-down 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

 

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

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.

 

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.

© 2024 Therefore Corporation, all rights reserved.