Delete airtable record when Calendar event is deleted

[L_V]

Hi there,

What I want to achieve is when I delete the event from Google Calendar, the record which is in airtable is also deleted (a record is created in airtable when the event is made).

I think this is an issue regarding filters or variables. The current setup does not move past the first module when I delete a calendar event so that first router is a failed attempt at fixing the issue. It is important the record gets deleted from airtable when the event does because this regards invoicing.

Thanks in advance kind people!

[samliew]

How is your Watch Events module set up?

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

^{(Note: Exporting your scenario will not include private information or keys to your connections)}

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.

A.

Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

• Either add three backticks ``` before and after the code, like this:

  ```
  <sup>input/output bundle content goes here</sup>
  ```

• Or use the format code button in the editor:
  

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

[ManishMandot]

Hey @L_V
May I know, Which filter are you using for deleted event ?
We have to first check if any event deleted on google calendar then it will fetch that event id and then delete that record from Airtable.

Thanks

[L_V]

@Growwstacks.com Currently the filter is if the event ID does not exist then delete. But obviously this doesn’t work because it doesn’t know what event to delete I suppose. Let me know if you need any more material to help. I appreciate it.

[ManishMandot]

Hey @L_V

1. Select this option to show deleted events

2. If its deleted then status will be changed to cancelled, so in the filter make a condition if status is equal to cancelled then it will delete that event from Airtable with reference of event id

3. For Created Event, use filter condition as status is equal to confirmed

Try this and let me know.
Thanks

[L_V]

The filter works great. As it is currently setup, deleting one event off the calendar triggers the scenario to go through the bottom route and instead of deleting the specific record that correlates with the one deleted in the calendar, it deletes all of them.

What would be the correct fix to make it only delete one specific record?

[ManishMandot]

@L_V

Have you saved the event id in Airtable?
If it is saved then fetch the data from airtable and then use filter after search records which will equal to event id from Google Calendar.

Then it will delete only that event

[ManishMandot]

@L_V
I’m pleased I could assist you. Kindly ensure to designate my response as the solution, which will benefit other community members should they encounter a similar issue in the future.