I am hoping to figure out how to prevent duplicate entries on a given date. For simplicity, I am building a scheduling platform and want to prevent the possibility of scheduling the same person twice in a day. I have name and date fields among others (times etc.) but just want to know that if I put "Jason" in to work Tuesday 10/13/15 at building A - that I he can't be scheduled on accident at building C on the same date. This system is actually scheduling staff in 40-50 locations so I'm trying to minimize the potential for human error. Any help is appreciated. Thanks much.
”Unique on 2 field" may be applicable.
Make an auto enter text field as
GetAsNumber(dateField) & nameField
then set validation "always unique".