Google Calendar to display events for longer periods than default set

AppSheet Tips & Tricks
, ,
1

Im not sure if this is officially documented or mentioned before in this community place, but I noticed that we are able to change the Google Calendar (as data source) events to be shown on Appsheet by chaning the value in JSON here.

3X_c_c_ccd64a375d906a8dda6b8cb95be8ac96c63d1964.png
3X_c_c_ccd64a375d906a8dda6b8cb95be8ac96c63d1964.png747×412 22.6 KB

By default, it is set to -90 / + 90, meaning the events with data for 180 day periods will be thrown to App with mean date today().

For instance, if we wish to get the events with date in the last year, change “FrmDasInThePast” key value to -365 like the screenshot as above.

10 Likes
2

In all the time I have been on the community, I have not heard mention of the Google Calendar integration capability…so I went looking and found this post that has a link to AppSheet article as well:

[Enabling app users to add Google Calendar events from your app](https://community.appsheet.com/t/enabling-app-users-to-add-google-calendar-events-from-your-app/8858) Tips & Tricks ?

[image] With a few steps, you can create custom actions to add events to a Google Calendar: Create a URL type virtual column using the following URL format, utilizing ‘Event Name’, ‘Dates/Times’, ‘Details’, and ‘Address’ columns : https://www.google.com/calendar/render?action=TEMPLATE&text=[Event Name]&dates=[Dates/Times]&details=[Details]&location=[Address]&sf=true&output=xml Ensure your start/end dates/times value is in this format like this example: 20190127T224000Z/20190320T221500Z …

Its been around since March 2019!!! I am going to get familiar with this immediately!!

2 Likes
3

It can come in handy for creating recurring events because you can just define the periodicity in GCal (First Monday, Monthly, Yearly, etc) instead of creating complex expressions and workflows in AppSheet.

4

Thanks for the info!
I have a question … How should I do if I want my calendar not to start at a certain time towards the step but to start from a precise date.
I tried to do it with different expressions but I can’t find the correct one.
I would appreciate it if you have that information! Be fine!

5

Maybe by setting the FromDaysInThePast?

[Google Calendar data source: Reduce sync time](https://community.appsheet.com/t/google-calendar-data-source-reduce-sync-time/48028) Tips & Tricks ?

If you use Google Calendar as a Data Source in your app, the standard setting is: It will read all data 90 days in the past and 90 days in the future. You can find this under Data > Tables > Your Calendar > Worksheet Name/Qualifier {“FromDaysInThePast”:-90,“ToDaysInTheFuture”:90} But this may not be necessary. If you just want to add entries to google calendar via your AppSheet App, but don’t have a calendar view you can change it to {“FromDaysInThePast”:-0,“ToDaysInTheFuture”:0} And/Or us…

6

I understand but but how for an specific date? I don’t want to ser many days in the past. I want to put since 01/06/2021.
There is a way for that?

7

No you cannot use a date in the FromDaysInThePast.
But you can work with security filter.

[Google Calendar data source Question](https://community.appsheet.com/t/google-calendar-data-source-question/54907/2) Questions

Once you add Google Calendar as a table, you would see new table called “primary” Go to the table settings, security filters, then apply expressions like AND( YEAR([Start])=YEAR(TODAY()), MONTH([Start])=MONTH(TODAY()) ) This will be pulling the google calendar events where event starts date fall within the current month you are on. [Snag_1a865783]

2 Likes