Hi Both, Thank you so much for all your efforts and help in trying to solve my problem, I will implement what Jeremy suggested next week and will give an update on the process. Have a great weekend!

Hi Bill, Thanks for your help and interest on this. We have various users booking kit and I wanted it to be flagged when someone books the same kit for the same day so we can prep alternate kit.

Sure, I work in a production company and we have various amounts of camera and lighting kit. That kit gets booked for location shoots almost on a daily basis, all the Kit is up on airtable as single items. The main fields are the Kit, date, and proje...

Basically is a film equipment booking base, for every shoot there’s various kit that gets booked and I wanted to flag if the same kit gets booked for the same date.