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.
Nov 14, 2022 08:48 AM
This is very helpful. I think I’m closer but still missing something!
A little confused on the “Record ID” picklist of list/grid view. And should I make the next step conditional? THANK YOU!
Nov 14, 2022 08:53 AM
Assuming Event ID is coming from your trigger, it will never be empty. Your condition should instead be “[Find Records → length] > 0”
Nov 14, 2022 09:02 AM
In the first action (finding the record)? Or the second action (updating the record)?
Nov 14, 2022 09:04 AM
The second. You cannot conditionally search for records if the search results in 0 results: how would Airtable know there are no results until it searches?
Nov 14, 2022 09:18 AM
Ah, of course. Okay, hopefully last question. Is there another formula or something for the “Record ID” after the condition is met? Feels so close… thank you for your help.
Nov 14, 2022 09:24 AM
You are still saying “use the Google Event ID as the Airtable Record ID”. You should be pulling the List of Airtable Record ID, not the List of ‘Google Calendar ID’.
Nov 14, 2022 10:56 AM
It worked!!! Thank you so much.