I may be going the wrong way around this. I am trying to send records from one table to another as a group of linked records. There are two condition groups for creating two linked records each time the automation is triggered.
Condition 1 is:
Farm contains "Ahoaho"
Status is "Sales"
Sales Summary (Linked Record) is Empty
Condition 2 is:
Farm contains "Ahoaho"
Status is "Sales"
Sales Summary (Linked Record) is Empty
I would like to be able to further group these by "like dates," so that stocktake records from different dates don't get linked to the same Sales Summary record.
My first approach was to attempt creating a repeating group based on unique instances of "stocktake date," however the repeating group function doesn't work like that.
Is there another way I can group records in an automation based on a date field?
