Grouped tabular fields allows the collation of records sharing common properties. Take this data for example:
To create a custom field that collates records sharing the same PRICE, the following is configured:
A simple script is used to pick out the ID column:
1 2 3 4 5 6 7 8 | -- Get the records in the group r = RECORDSET.getgroup(); -- Create a table of IDs t = r:tableof("ID") -- Return the table t:present(); |
Notice the Group Path: has been configured with the name of the PRICE field. This groups all records with the same value. Any number of fields can be specified by separating them with a colon. The resulting is shown below:
Because one table is created per PRICE, all links inserted are shared, so placing one will flag other with the same Shared IDs as placed:
