I want to unsync Google Calendar table

AppSheet AppSheet Q&A
,
1

Hi,

This app uses the primary Google Calendar of 10 users as a table.
Only the logged-in user’s Google Calendar will be displayed as a slice, and the data will be passed from the spreadsheet to Google Calendar for updating.
(Data: Set the values ​​for some columns in this row)
Therefore, I want to sync only the logged-in user’s Google calendar and I don’t want to sync other users’ Google calendars.
This is because synchronization takes a long time.

To unsync each Google Calendar table …

Do you put the expression in “Are updates allowed?”
or
Would you like to put the expression in a “security filter”?
The creator of Google Calendar is the creator of the app, not the logged-in user.
I created an owner with USEREMAI () in VC, but I couldn’t specify VC as the column in the expression.

what should i do?
please tell me.

Thank you.

Maki

2

A security filter is your only choice.

You can use USEREMAIL() directly in the security filter expression, no need to use a virtual column.

1 Like
3

Thank you Steve.

I put the following expression in the security filter and it was almost solved.

OR((USEREMAIL()=“user001@domain”),(USEREMAIL()=“admin@domain”))

It will not be reflected until a little time has passed, so I thought it was useless at first.

The “Appsync” log for user002 is as follows:

Read a single table 00:00:00.8478195 {“TableName”:“user001@domain”,“Timestamp”:“08.53.19.903466”}
[internal] GetTableData 00:00:00.8477653 -
[internal] DataLayer_GetTableData 00:00:00.8477389 {“TableName”:“user001@domain”}
Read table rows 00:00:00.5033412 {“RowsRead”:“0”,“ColumnsRead”:“0”}

Since the contents of the Google Calendar table of user001 have not been read, the sync time has been reduced and it was almost resolved.

2 Likes