I have a scenario where users are to book sessions with date and time. Currently, I am trying two ways to enforce unique values for date and time.
I added a date picker. I added a formula to validate the date to be only Fridays. But I need the time to be customized such as only time are shown e.g. 2:30 or 3:30 or 4:30 to be selected from. If I can customize it in such a way, I can enforce unique values easily.
If not, I have created 2 columns; date picker with date only and time as a drop-down choice. But how can I enforce 2 columns to be a unique value?
Kindly advise, I am open to suggestions