Automating update record when an Outlook calendar event is changed

[Aubin]

Hallo everyone,

During these holidays I am evaluating Airtable as our company new CPRM. Trying different functions…
We prefer to create event in our Outlook calendar and would like to create and update records in AT CPRM base Activities table.
I found the way to create record via automation.
I am having issues on updating the record when the event is changed in Outlook calendar.
Could you please indicate me the way forward or around?

[ScottWorld · Accepted solution]

Hopefully the article below will help you out. Be sure to store the Outlook Event ID for each record in Airtable, or else you won’t be able to specify which record to update.

Airtable Support

Outlook automation triggers

When building an Automation we offer several triggers that can be used with Outlook including: When a new email is received in Outlook Email When an event is created in Outlook Calendar When an ev...

[Aubin]

It works! thank you Scott. Now I am trying to delete record if outlook calendar is delete.
I understand I have to use script, but I cant find one good example in the community, any tips for that one?

[ScottWorld]

Sorry, I don’t know much about that, but others here do. Personally, I typically use Integromat to automate the deletion of my records:

Integromat

Microsoft 365 Calendar Integrations

Integromat gives you the ability to integrate Microsoft 365 Calendar with many other services.

Integromat

Airtable Integrations

Part spreadsheet, part database, and entirely flexible.