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.