ct4.us

Read a record field value from selected table.

Basic usage:

{{ tables.getvalue }}

Usage with parameters:

{{ tables.getvalue(Table, Value Field, Record ID or filter, Order By Field) }}

Parameters:

1. Table (optional) – The name of the Table that has a Table Join type field.
2. Value Field (optional) – Field of joined table to read the value from.
3. Record ID or filter (optional) – Example 1: 65, example 2: population>1000000
4. Order By Field (optional) – Optional and is used with the Filter not Record ID

Example:

{{ tables.getvalue("products","_id",62) }}

If Record ID or filter not provided then the first record in the table. This can be useful to show last record ordered by date for example.