I am trying to check a SharePoint list column value before having data be submitted. The column is a simple Number field that will be counting down to 0 as users submit data.
To elaborate: It's essentially an appointment booking system that doesn't use forms in any way - just text inputs and gallery selections. I'm having a difficult time trying to account for not having the data in "real time" where two users could essentially select an appointment that only has 1 slot remaining and double book it. I know this can be accomplished with a simple refresh timer, but that has it's own problems with performance and doesn't really look great with the constant loading dots at the top of the screen.
All I'm trying to accomplish is to have a "loading spinner" type deal that triggers on screen for the user, goes and checks this column called "Slot Count", and if the value is not 0 to submit the data. If the value is 0 I want it to stop, inform the user that the appointment is full, and allow them to select another one. I tried to use LookUp with IsBlank but either I'm not doing it correctly or it won't work for this scenario.
List information:
"Vaccine Appointments" with two columns - "Time" and "Slot Count"
Relevant Screens:
"Appointment Selection" with a gallery pulling from the above SharePoint list. Has a button under each time slot to select the appointment and go to the next screen called "Appointment Confirmation."
"Appointment Confirmation" with labels displaying appointment information and a confirm button to then do the check and submit the data as long as the slot count isn't 0. If the slot count is 0, it'll inform the user with a popup and once they select OK it'll return to the "Appointment Selection" screen.
Thanks!
