Hey there! I am a true beginner to automations and coding in general. I’m hoping this community can help me with this.
Applications: Airtable (Pro plan), Google Cal, Gmail (if needed: Zapier, Integromat)
I have a team of multiple people who are assigned to certain events. They are in a multiple select Field “Onsite Team” with options like: Judy (lead), Judy (asst), Ben (lead), Ben (asst), etc… where each person can be 1 of 2 roles and we have at least 2 ppl assigned for an event. Ex) EVENT X has Judy (lead) and Ben (asst).
What I want to automate:
- Find EVENTS (records) for Judy that have her assigned, either as lead or asst, and create a Google Cal event for her (with info from Airtable like event address, start date, time, etc…)
- If Airtable is updated (like date or time changes), I want it to automatically update the created Google Cal event.
- If Judy is no longer assigned to that Event, I want her Google Cal event to delete.
- Repeat for other team members.
What I’ve tried:
I’ve started using the Airtable automations feature but I haven’t been able to update events, just create them. I’ve also read multiple info docs, mostly on formulas, but it’s all Greek to me and I need a bit more help/explanation.
Thank you!
