Looking for a way to add entries to a subtable automatically based upon dynamic filter setttings applied to linked sheet. Currently the dynamic filtering can be used to show select records to choose from but requires selecting each individual record. This is slow and error prone as duplicate entries are allowed and only flagged when trying to save the record. Preferred action is to have the subtable entries auto added based upon the dynamic filter and automatically add to subtable.
Hi,
Automatically adding records to subtable based o a field value which is matched the value on another sheet is not supported through design tools. It needs custom scripting to achieve this, here’s Ragic Javascript Workflow guide which developers can refer to.
How do you trigger the sync by CUD to the source of the subtable?