Form / Calendar Integrati

I have a few ideas...

1. Exactly as you specify? No. But publishing both tho a dashboard would give you the ability to display them side by side as opposed to two separate windows.

2. A filter or conditional formatting to gray out the unavailable times/dates.

3. It is possible, but details will determine exactly how to set it up.

.

One of the ideas I am kind of thinking on is this:

Create a sheet. If there are 25 openings on a day, each day could have 25 rows.

You can lock the columns that you don't want the users to edit, switch it over to Calendar View, and then have people just double click on the appropriate day/time slot that they want to book and edit the row directly (except for the locked columns of course).

From there you can use conditional formatting to gray out the bar on the calendar and use an Automation to lock that row to keep people from being able to "steal" the spot once it's been booked.

.

Another way of doing something very similar to this would be to display the sheet as a calendar as "View Only" on a dashboard and have a form with just three fields on it (Email, Date, and Time Slot) that goes to a different sheet. You can use a checkbox column on the calendar sheet along with cross sheet references to check a row when someone requests it.

Then you can have an update request sent to the email address triggered from the row becoming checked in the Calendar sheet.

The update request will allow you to really drill down on which columns can be seen and edited.

The requester will get an email, fill out the Update Request, and submit.

Then you can use the conditional formatting and Automation to gray out and lock the row.

If someone submits a request for a date and time slot that has been grayed out and locked, they will not receive the update request.

You can include some basic instructions using a rich text widget on the dashboard letting them know to only request time slots that are available (not gray).

Another though just struck me on this as well... A helper column on the form sheet that flags any duplicate entries.

Set up an Automation to send an Update Request anytime that flag appears to the email address associated with it prompting them to select an available time slot.

Ok. Well to populate a calendar with the available slots remaining, we can use a pretty basic sheet. They key is going to be the Primary Column. I'll rename it "Available Slots" for this example. I also have the following columns on this sheet:

"Date": Date type column with each possible day in it going down the rows.

"Total Slots": Text/Number type column where you enter the total number of slots for that day.

"Slots Used": We use a cross sheet reference in a COUNTIFS formula to count how many times that particular day appears in the Date column of the Register.

=COUNTIFS({Register Dates}, Date@row)

.

Then in the "Available Slots" column (needs to be the primary column), we can use this...

=[Total Slots]@row - [Slots Used]@row + " slots remaining"

.

This will automatically calculate the number of remaining slots for each day, and display that with the ending text.

See screenshots for visual example.

Note: I added in some conditional formatting to the Task Bar just as a visual reference for how many slots are available per date when looking at the calendar view...

You can publish the dashboard and send out that published link. With the form link on the dashboard in a Web URL widget, they will be able to view that alongside the calendar (how you put the calendar on the dashboard is up to you). 

Send out the published link to the dashboard itself, and you should be squared away.

Can you create a Appointment Schedule with Time Slots?

@Travis Spears Are you able to provide more detail?

@Annie Prescott I'm glad my explanations are easy to follow. I try to explain the "why" and "how" so that they can be adapted to fit other applications as well as to try to teach so that others can become more proficient.