Related entity multiline decimal

[DESCRIPTION]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: [YES/NO]No
• Show in lists: [YES/NO]No
• Searchable: [YES/NO]No

User interface

Field in show mode

[INSERT IMAGE]

Field in edit mode

[INSERT IMAGE]

Configuration

[INSERT IMAGE]

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 *[EventuelDataID]*, beskrivelsewhere af*[DataID]* configs]will be replaced be the current records DataID.

Config2

The Label of the input column in the table.

Developer info

• FeltTypeID: 232
• SQL datatype: INT(11)
• Class name: FieldMultiInputSubformListSQL