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).
@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.
User | Count |
---|---|
18 | |
15 | |
10 | |
7 | |
4 |