Google Calendar to display events for longer periods than default set

[tsuji_koichi]

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.

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.

[WillowMobileSystems (John Baer)]

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

[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!!

[GreenFlux (GreenFluxLLC)]

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.