What event actions in an application work on a Subtable Main?

Nextworld Platform
1

I am working with an application over a table that has 2 subtable main data items. What happens on the first subtable main, impacts what should happen on the second subtable main. For example, if a record is inserted into the first subtable main, then related records need to be inserted into the second subtable main. If a record is deleted from the first subtable main, then records need to be deleted from the second subtable main. If a field value is changed on the first subtable main, then both delete and add records into the second subtable main need to occur.

I have read some of the topics on subtables but wanted a clearer picture of what actions in an application actually work for a subtable main. I have tried a FVC of a field on the subtable main and that triggers a logic block okay. I am now trying to trigger a logic block on Row Delete of subtable main record but that doesn’t seem to trigger the logic block. Should this work? Is there a list of what application actions will work on a subtable main?

2

The “Logic blocks and event actions” help article covers this in some detail. Generally speaking, field-level actions work for subtables but row-level actions are not currently supported.

To add or remove records from one subtable while adding, changing, or removing records from another, your best bet will be an action block over the parent table rather than UI-based logic. The action block can easily determine which records currently exist in the first sub main, in your case, then rebuild the second sub main accordingly.

1 Like