Thanks, yes, initially this is about vaccinations but we are concerned with overloading the server as this is in a major city and we'd assume way too many people applying at the same time so any lookups would be out of date by the time they hit "Submit".  Have you seen any issues with that?

Hey Bryan, The process Cliff is referencing is our process.  We do experience some duplicates.  This generally happens on initial release and it seems to happen with even times like 1pm, 2pm, not so much the 1:10pm or odd slots.  One thing we've done is put the lookup at the bottom of the form so when the date is chosen and the lookup for time slots are done its basically sign and submit.  We initially ran the process with flu vaccine last fall and obviously with flu vaccine were not limited on supply so an extra appointment or two isn't a big deal.  Were now running the same process with COVID19 vaccine and so far we've had a few duplicates but with cancellations and no shows were still scrambling to give away our extra doses at the end of the day so were doing okay.  I will say the more dates/times you have available the less duplicates happen.  Were taking in ~500 forms a day right now with tier 1a and 1b and scheduling a range of ~40 to ~100 appointments a day depending on location and staffing.  It's not perfect but functions really well for us.  Maybe someday Cliff and I will have time to sit down and improve it but with a 3 day launch window we're doing the best we can.