Show availability in Calendar (instead of occupation)

[fery]

Hi,

I would like to reverse the Calendar view from occupation to availability.

What do I mean by that? In month view I have ‘marked’ days when I am busy (have meetings, phone calls…), but instead of that I want to see days, when I have nothing, I am available.

I would like to compute that in days, not in hours. Is there any way how to proceed?

Thanks.

[MultiTech]

Hello @fery

I can’t really think of an easy/good way to do that. The problem you’ll find is that since there’s nothing to display or work with (since we’re talking about times when you have nothing going on), the system can’t really do anything with that.

You’d need to create some sort of stand-in or placeholder for each of the empty spaces…

[fery]

Thanks for your answer I thought that this would be a problem.

[GreenFlux]

MultiTech_Visions:

You’d need to create some sort of stand-in or placeholder for each of the empty spaces…

Yep! That’s how I built my calendar app. One row for every 1-hour block, that’s related to any events that fall in that hour.

CRAZY CALENDAR HACK: Add Events Directly to a Timeslot, Pre-Fill Date/Time Tips & Tricks 💡

Hold on to your apps, this one is gonna get a little weird. The default calendar view doesn’t provide a way to pick a timeslot when opening the form. I came up with a hack using a new table that contains only one sheet column for the hour, and 7 virtual columns for the day of the week. [Screen Shot 2020-11-16 at 3.14.35 PM] From there, I have a table view that shows related events to every Hour, pulling only events from This Week (Slice). Then, I created 7 Edit actions, …

---

@fery,

You can also share your calendar publicly, but only show availability, without disclosing the event details.
https://support.google.com/calendar/answer/37083?hl=en

Another option is to integrate with a booking service, like Calendly, or 10to8.