Synchronization with Google calendar

[UadoS]

Good time everyone.

The AppSheet gives you the opportunity to add Google calendar as a base.
But not all the columns that Google Calendar has can be managed in the appsheet application.
The ability to work with the calendar is a VERY good addition to the appsheet application. But it seems to me that this is not yet a ready-made tool for proper and maximally correct interaction with Google calendar.(as conceived by google developers)

Are the appsheet developers planning to add all the missing Google calendar parameters and columns?

Is there a way now using appsheet to get all the missing columns from the connected Google calendar and be able to work with them?

For example, there are not enough statuses of invited people to the event who have registered in the event, will they, no or maybe.
If we compare the service for example automate.io then there they have 23 columns available for transmitting data from the created event. There are only 12 columns available in the appsheet app.
When creating an event from appsheet, there is no way not to create a google meet conference.
Well, or why does appsheet make it possible to create an id key for a Google calendar event, because Google calendar generates its own unique beter id key itself.

[Koichi_Tsuji]

Thanks for your question.
Google calendar and Appsheet integration is pretty much limited, so we never used for our prod app pushed to users just because of such a limitation.
Interesting to see how the discussion will grow here in your thread.
My assumption is Appsheet is using Google calendar APIs for integration, where the “Auth” scope is limitting our capabilities. For instance, when other users add new event, it is always registered as the app owner generated such new event instead of app user etc. UI(calendar view) is totally different from Google calendar native etc.

[WillowMobileSys]

Below are a couple of articles that may provide more info.

META POST: URL Parameters for other Google Services! Resources

I just saw a great tip about creating Google Voice Links by @Peter and it got me thinking; It’s time for another META POST! Previous Meta Post: META POST: Deep Links & URL Parameters Google URL Parameters This meta post will be a collection of Tips & Tricks for passing URL parameters to other Google services! Google Calendar Gmail Google Maps Google Voice Google Meet Google Image Search YouTube Other Resources https://output.jsbin.com/xujuluw http://kalinka…

Add event to Google Calendar not from iCal Files, but from URLs Tips & Tricks 💡

AppSheet is natively support to generate the iCal files out of BOT jobs to sent the ical file to recipient to add the event to the calendar. But it is bit painful for Google Workspace | Calendar users as ICal file is not easy to add event to Google Calndar (yes we have option to add event out of iCal file though) To make the life for Google Workspace user easiers, we are recommending to make action to go to URL to add event to Google Calendar. To add event, just construct the URL (within VC) b…

[UadoS]

I think that these ways of solving the problem, how to describe them like this, are some kind of crutches, not a solution to the problem, yes, the ways may be working, but not quite and not quite as we would like and maybe not as intended in the appsheet application. It would be much easier to add columns that are missing, get event information from Google calendar into these rows, change it using formulas and send it back. Isn’t that how appsheet works? (probably)

[WillowMobileSys]

UadoS:

not a solution to the problem,

I agree.

But I also do not think it is feasible for AppSheet to provide robust UI integration with EVERY service App Creators may want to use in their apps - regardless if its a Google service or not. (Ephasis on UI. Automation is different. Here we are referring to user facing UI concepts)

Could you not just provide a button to navigate to the Google Calendar web site for Event entry? Why replicate, even part of, the Google Calendar UI in AppSheet?

For comparison, we use our Mobile devices everyday to accomplish many different Tasks in many different Apps. I don’t think it is a stretch at all that AppSheet apps do the same. And I don’t think it would be an issue for end users. Tech savvy users are already use to switching between apps.

So, I think it would be MUCH better to focus on seamless (and efficient) navigation to and from AppSheet to Third-Party apps/web sites. E.g. I have seen the little back navigation link in the upper left corner to get back to the previous app.

[UadoS]

My idea is that the user uses only Google calendar (I believe that it is impossible to strain the user with other applications, when there have already been working schemes for years, AppSheet in this case acts as an excellent tool for managers of administrators and they need to be used). Google Calendar is a tool for organizing people, when, who, where, and event description. User feedback is a button in the calendar, I will be at this event, or I will not be at this event.
Again, Appsheet is a tool only for the organizer. The first part of the task works, Events are created, but then invited people are marked in the Google calendar, then this cannot be tracked using the appsheet application in any way.
The first method is google sheets and automate.io and other services
Another way to learn javascript and start using google script. But this is not a solution to the problem within the appsheet

[Steve]

Attn @Arthur_Rallu