Help

Grouping records based on like dates?

Topic Labels: Automations
332 0
cancel
Showing results for 
Search instead for 
Did you mean: 
oreocereus
8 - Airtable Astronomer
8 - Airtable Astronomer

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?

0 Replies 0