Creating an Event

The minimum information you need to create an event is the Summary [Text], Start [Date and Time], and End [Date and Time]. A “Results” column is optional, but I find that there are big advantages to including it, so I create an Event [Google Calendar] column and use it for the value returned by the pack when the event is created. This value is the Event URL and the pack uses it to sync information back from Google Calendar. Set this column’s type as “Google Calendar Event” and you’ll see a nice chip style entry with the rest of the info displaying when you hover.

I also find it useful to go ahead and include a Description [Text] column and Attendees [People] column.

There are many other options you can include depending on your needs. You can find available additional fields by clicking on “+ Add More”.

⁠

Disable the button

We can only create an event if it hasn’t already been created or if all the minimum information required is present. If we disable the button for these cases, it’s a good visual queue for anyone using this template that more information is required or to see if the event already exists. The formula we use here is...

⁠

This formula checks if the event has already been created OR if any of the required fields IsBlank() and disabled the button accordingly.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.