Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Identifying clashes using linked feilds

Topic Labels: Formulas
168 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

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