Identifying clashes using linked feilds

Topic Labels: Formulas
447 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


I am trying to identify clashes when scheduling shows in Airtable.

I am dealing with performance groups some of which share the same members I am working with 4 tables one containing all of the ‘ensembles’ a second with all the individual members of each ensemble (Contacts) which are linked to all their ensembles. Thirdly a schedule which links each ensemble to a venue, start time and finish time.

I would like to find a formula which will flag a show as a clash if contacts are linked to multiple ensembles with the same start time?

Any help please, I am banging my head at the table…

0 Replies 0