Forms › The Form Designer › Form Element Functions › Form Elements › General Functions for All Form Elements › ca_pam_showDataInTable(result, _id, tableHeader)

ca_pam_showDataInTable(result, _id, tableHeader)

Displays data rows that result from a Lookup field function as a single-column table that has the specified header or title.

This function only displays the "result" passed to it. The result here represents an array of rows. The result can be either stored in a variable and passed to this function, or directly replaced with the function call that returns the result.

Input Parameters

result (object)

Specifies a function call that results in the values displaying in a table.

_id (string)

Specifies the unique identifier of the Lookup Field table in which to show the result set.

tableHeader (string)

Specifies a text string to display at the top of the Lookup Field table on the form.

Return Value

No value is returned; this function only displays the table with the values included in it.

Example

ca_pam_showDataInTable(result,'Form.office','Office');

This example shows a table named Office that lists the results of a separate query to get office names. In the separate query, the user Region selection determines the offices to display.

The onLookup event for a Lookup Field named Office calls this function.