Issue with Google Calendar

Hi,

I try to link my Google Calendar entries with my Client table. I read this page :

and tried the formula GCAL_MEETINGS_WITH(“Calendar”, [Email])

I have an issue while using the formula in a virtual column of the Client table :
Capture1

even if I used the process to add a table from Google agenda entry.

However the Data source of google aganda table looks different :
Capture

Any idea ?

1 Like

Hi Christophe,
I have the same issue. Did you find a solution?
thank you very much

Please contact support@appsheet.com for help with this.

I could reproduce the error on a test app, and reported it to our engineers.

For now I suggest using a workaround formula like this:

SELECT(Primary[Title], IN([_THISROW].[Email],[Attendees]))

Assuming “Primary” is the name of the table that is linked to your Google calendar data source, and [Email] is the email address of the person you have meeting with.

1 Like