Jun 21, 2021 07:47 AM
I have created an automation to add in a specific google calendar an event when the date and time is indicated in a specific field called “Follow-up Meeting” in my airtable database. It works.
Now, I would like to update the event in google calendar if the date and time in the field “Follow-up meeting” in airtable is updated. I have created a trigger but I have a problem as I cannot inform the “Event ID”. What should I do?
Jun 21, 2021 04:33 PM
In your first Automation add an Update Record step that fills in the triggering record’s {Meeting ID}
field with the ID of the event created in Google Calendar. If you don’t have a {Meeting ID}
field, make one.
Now that you’re storing the event IDs you can update the correct event associated with your Airtable record. You will probably have to manually fill in the meeting IDs that have already been created.
Jun 21, 2021 06:32 PM
As I am a new user, I am. not sure to understand how to do this, could you be more specific. Thanks so much I appreciate your support.
Jun 22, 2021 09:10 AM
In the automation you already have:
Update record
step after the Create Google Calendar
step.field ID
box, click the blue plus symbol to select the trigger record’s record IDFields
select Choose field
and pick a single line text field that you’ll use to store Google Calendar Event IDs. Click the blue plus symbol to select the event id
from the Create Google Calendar
step.Now in addition to creating a new Google Calendar event, your Automation will store the unique ID of the calendar event item as a field value for the relevant Airtable record. This means you can update the calendar event in the future by referencing this ID.
Create a new Automation that has these steps:
{Follow-up meeting}
time is updated.Update Google Calendar Event
step. For the Event ID
click the blue plus symbol to select the trigger record’s {Calendar Event ID}
field.Jun 22, 2021 04:34 PM
Thank you, I could not follow those instructions but I found a bot which can do this.
Dec 14, 2021 02:49 AM
Hi
I tried this method but I’m facing a failed test
The test for the trigger is OK
The test for the action failed “Received invalid inputs”
These pictures will show you
Have you an idea to fix this ?
Dec 14, 2021 09:22 AM
Your test shows that you passed in no event ID. Whichever record is being used to test your trigger didn’t have a value for that field, so you’re not going to test the action steps until your test record is updated (and the trigger is re-tested to pick up the change).
Dec 14, 2021 10:59 AM
I succeeded
Thanks for the trick
Nov 11, 2022 05:43 AM
@Kamille_Parks – this was very helpful, thank you!
Can you advise on creating the reverse automation? One that will update the Airtable due date when the GCal event date is moved? I’m not sure where to put the single text field that I created to store the unique identifier from Google Cal, and also not sure if the issue is that the start and end date nature of the all-day event in Google Cal is incompatible with the “due date” field in AT.
Nov 11, 2022 04:46 PM
Your screenshot shows the same misstep. You’re passing the Google Calendar [Event ID] to the Airtable [Record ID]. Those by definition can’t be the same. Add a Find Record step before your Update Record step that searches Airtable records where {the field you're storing the Event ID to} = [Event ID from trigger]
. Use the result from the Find Records step as your Airtable Record ID in your Update Record step.