Auto updating form field dropdown menu based on entry submissions

plenge

I am trying to create a form that gives users dates and times from a dropdown list to sign up for coaching sessions in a way that when one person has selected a given date and time it doesn't allow another person to select that time and disables/eliminates it as an option from the form field dropdown menu. Is this possible with some sort of autolocking of a dropdown option when it has already been selected or any other way? 

Kerry St. Thomas

While it's conceivably possible to do what you are envisioning, it's not scalable (the column's dropdown options would need to be changed with every request - meaning you'd either have A LOT of manual retooling or several instances of Data Shuttle, and it still won't eliminate the possibility of a double-booking). Instead, you may want to consider using a "first / second / third choice" model for signups, and an approval process so that the requester gets a confirmation of the approved time when a schedule is finalized.

Perhaps you can surface the "Current Coaching Sessions" calendar on a dashboard as a view-only point of reference, and then the form as web content on that same dashboard to help people to self-correct to available times.

Good luck!