Skip to main content
Solved

Automating update record when an Outlook calendar event is changed

  • December 24, 2021
  • 3 replies
  • 67 views

Forum|alt.badge.img+3

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?

Best answer by ScottWorld

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.

3 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • December 24, 2021

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.


Forum|alt.badge.img+3
  • Author
  • New Participant
  • December 27, 2021

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.


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
Forum|alt.badge.img+35
  • Genius
  • December 27, 2021

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?


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