Help

Check for clashes and then update a field

Topic Labels: Automations
610 0
cancel
Showing results for 
Search instead for 
Did you mean: 
YargJay9991
4 - Data Explorer
4 - Data Explorer

Hey there!

I have a table with a bunch of records each with a date field (with time). Whenever I create a new record in this table, I need to check all the other records for any clashes with my new record, based on it's date field.

If a clashing record has the same 'Booking ID' as the new record, we ignore it as a potential clash.

Then I need to update the 'Conflicts' linked records field of the new records with all of the records it clashes with.

Then I need to update all of the clashing records with the new record in their corresponding 'Conflict' linked records field.

 

I have tried sooo many different coding options, even tried AI code writing, where I can get close but never get it to function properly. This is all in an automation script too. 

 

Any help is appreciated!

Jeremy

0 Replies 0