Trying to disable submit button if room is not available.
I am trying to disable a submit button on an edit form if a rooms' time slot is already taken and approved.
This is what I am working with:
Data Source: SharePoint list (Calendar) called- Calendar_Test
I have an edit form that I am trying to validate the information with the data source. I am trying to validate the following columns:
*Start Time (date and time column): input on the edit form is dp_NewStartTimeDate and dp_NewStartTimeHours
*Time Slot (single line): text input on the edit form is txt_NewTimeSlot
*Approved by SSR (choice): (Pending, Approved, Denied) drop down input is dd_NewApprovedBySSR
What I am trying to do is disable submit button If(any item that is pending or approved in the data source and at the same time and date with the same time slot not be able to add a new item that matching that criteria) disable button until time or date is changed to not conflict with another item. I am only working with 1 rooms' schedule.
Is this possible? I have been trying to figured it out for days and I feel close but nothing is working.
Any information on this would be greatly appreciated.