Calendar

Lido provides action formulas for creating and managing calendar events in Google Calendar and Outlook.

---

ADDCALENDAREVENT

Creates an event in Google Calendar.

Syntax:

=ADDCALENDAREVENT(credential, title, start_date)
=ADDCALENDAREVENT(credential, title, start_date, end_date, description, location, attendees, status_ref)

Parameters:

Parameter	Description	Required
credential	Google Calendar credential ID	Yes
title	Event title	Yes
start_date	Event start date/time	Yes
end_date	Event end date/time	No
description	Event description	No
location	Event location	No
attendees	Email addresses of attendees	No
status_ref	Cell reference to write status	No

---

ADDOUTLOOKCALENDAREVENT

Creates an event in Outlook Calendar. Same parameters as ADDCALENDAREVENT.

---

UPDATEOUTLOOKCALENDAREVENT

Updates an existing Outlook Calendar event.

Syntax:

=UPDATEOUTLOOKCALENDAREVENT(credential, event_id)
=UPDATEOUTLOOKCALENDAREVENT(credential, event_id, title, start_date, end_date, description, location, attendees, status_ref)

Parameters:

Parameter	Description	Required
credential	Outlook credential ID	Yes
event_id	ID of the event to update	Yes
title	New event title	No
start_date	New start date/time	No
end_date	New end date/time	No
description	New description	No
location	New location	No
attendees	New attendees	No
status_ref	Cell reference to write status	No