FieldMultiInputSubformListSQL

Related entity multiline decimal

A table of lines from another table, maybe with a filter that relates them to this items DataID, and the option to input a decimal number next to each of them.

Properties

• Type: Complex
• Groupable: No
• Show in lists: No
• Searchable: No

Configuration

This field requires configuration of both parameters before it shows.

Config1

The SQL-query executed, to list the items in the table.
The first column should be *DataID* of the subitem, but it doesn't have to be. As long as *a* column includes this data.
To relate the subtable to the current item, ad a *where clause* comparing to *[DataID]*, where *[DataID]* will be replaced be the current records DataID.

Config2

The Label of the input column in the table.