Using form for book appointment times

Haley W

I want to use a form to allow sign up for meeting times. I would need the times available to either disappear after someone has selected it or be marked as unavailable automatically on the form. I thought to try locking the column after it is checked but that still allowed entry of data through new form submissions.

Bassam Khalil

Hi @Haley W

Hope you are fine, to do that you need the form to perform a search using a formula and unfortunately this isn't available in forms now, but you can design automation sending an update request ( with his submitted row )to the user after he signs up to show that the date he selects isn't available and give him a list of available dates.

Gwen Rymill SBP

Hi Hayley,

We covered a similar request in our recent Office Booking Tips and Tricks webinar which we are repeating on 3rd Feb if this is helpful ? https://www.smarterbusinessprocesses.com/new-for-2021-smartsheet-tips-and-tricks-webinars/

We also briefly demonstrate our Vaccine Booking Solution which takes appointment booking to the next level https://www.smarterbusinessprocesses.com/smarter-vaccination-bookings/