GCal expressions not recognising google_calendar source

[Kelly_BPZ]

Hi All,

We have a few apps that access a google calendar as a source, which works fine, however, whenever we try to use any of the G_Cal expressions we get this error;

 

We believe we have added the source correctly, the sources and table lists are as follows;

We've removed the calendar as a source in the app and account, removed Appsheet from the google account, logged out and back in, re-added the source and still no joy. Note that when the calendar gets added each time it initially is added as google_calendar-1, so I suspect this may be the root of the issue, however, renaming when following the remove/add process below (it's been done on 5 occasions now) still does not resolve the issue.

Hoping someone can provide an answer, or potentially another way of providing a list of company attendees without the use of the GCal expressions.

Thanks, Kelly. 

[Steve]

You're using GCAL_MEETINGS_WITH() incorrectly.

Use data from Google Calendar - AppSheet Help

[Kelly_BPZ]

Hi Steve,

Following the guide,  made a new app with the exact table names, I still cannot get that expression to work, the same error persists.

Any other advice?

Thanks, Kelly.