Linking or syncing Google calendar is not updating the appsheet calendar?

AppSheet AppSheet Q&A
1

Hi.

I have a table displaying in calendar view on appsheet.

I have decided to link a Google calendar to the account so that anything added to Google calendar will show on the appsheet calendar.

So far I have added Google calendar as a data source.

Then gone to data + source Google calendar, primary.

I have created a menu view, set the source as Google calendar.

If I make a change to Google calendar elsewhere, the g cal updates within my app.

But the appsheet calendar doesn’t show the new booking.

The documentation / previous answers I have seen said that if you add g cal as a source and create a view for it, the two calendars will sync automatically.

Is there a step I am missing?

(the main purpose of adding gcal is really just to be able to easily add recurrent bookings).

2

If that’s the case, then what else do you need?

It sounds like you may have two separate tables in your app–one that uses Google Calendar as a data source and another that uses a different data source, such as a spreadsheet. If that’s the case, perhaps you simply don’t need the table that doesn’t use Google Calendar. If you do need both for some reason, they won’t sync to each other automatically–just like any other two tables in an app–but you could create app functionality that replicates data between the two (e.g., Example: Copy updated records - AppSheet Help).

1 Like
3

Hi, thanks for the ideas.

The reason I need Google Calendar is to be able to create repeat bookings easily.

The reason I need appsheet calendar is because Google calendar only has limited fields on the form to record the info I need.

Is there a way of repeating bookings on Appsheet calendar? I think I found a help article with it on but can’t find it again.

Or is there an easy way to use an action which says,

When Google calendar gets a booking

Say Name, date and time, then, copy the data from name date time, and fill in the appsheet table, name date time?

I tried to do it using action, “Effect: Data: add a new row to another table using values from this row”
From Google Calendar Primary
add a new row to EVENTS (appsheet table)
NAME = Category
START DATE/TIME = START DATE/TIME

Should this work? As it doesn’t at the moment.

4

You could include that action in an automation whose event is triggered anytime a row is added to the Google Calendar table.

1 Like