Hi - I have Google Calendar and Google Contacts packs installed.
In my calendar, I would like to be able to view my interactions with “Attendees”. For example if my attendee is John Smith, and I’ve met with him 3 times, I would like to be able to see the 3 meetings I met with him.
I would also like to be able view John Smith in my contacts, click on his name, and see that I’ve met with 3 times.
I’m getting stuck writing a formula that can do any of the above despite the fact that I have both Google Calendar and Google Contacts packs installed.
Any help is much appreciated - Thanks
Hi @Adrian_Grant,
And welcome to the community!
I think you’ll want to match up email addresses to filter the table results to ones that match. You can get a few more things from the Google Calendar events table as well, like meeting attendees that have accepted the event and that might help here.
I created a template that is all just one table shown in different views to show each part works. It might give you more ideas on how to connect the two.
https://coda.io/@ben-at-coda/create-google-calendar-events-and-send-gmail-invites
Let us know if you see what you need there as a start, and if not, we can look deeper into writing the formula too.
Thanks @Ben_Lee - will see if I can tweak this to what I want