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

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). 

0 3 705
3 REPLIES 3

 


@JimandToby wrote:

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


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).

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.

 

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