So I’m trying to add a feature to allow my users to assign meeting to other users based on their google calendars. So set A of users need to assign set B of users meetings during a block of time that will be managed by set B on a per user basis. The managing of these blocks should be done in google calendars as my users are already fluent in using it. I have no experience using google calendars or using calendars in appsheet at all. I just want to know if this is a viable thing to do in appsheet and if there are any useful samples, videos, articles before I spend a week or so developing this.
First, I am certain that you can tap into the Google Calendar API and grab that calendar data. But since AppSheet currently cannot pull info from Third Party sources, you would need to do it from your sheet and capture that calendar info as rows that you can then surface in an AppSheet app.
If you want your users to manage the calendar info within Google itself, you also can certainly navigate to the Google Calendar from AppSheet using the URL of that calendar.
I know these things are possible but I do not have specific examples or documents to help.
In AppSheet, the Calendar view is a basic view that will allow you to show events/appointments based on your data as colored blocks. You specify in the view where to the find the Start and End times within your row.
You can Categorize entries - for example by Technician or Customer or Employee - and the Calendar will try to keep entries in the same Category with the same color (Colors can repeat if more Categories than supported Colors)
When you tap an entry, it will navigate to the Detail view for that datasource.
Events/appointments that overlap are handled. See below examples.
Daily Calendar view Categorized by Technician (Note Red is used for 2 techs)
Also note that the entries at the top are “All Day” entries
Sample Weekly view
Sample Monthly View
1 Like
You can use Zapier or Google Scripts to move data between a spreadsheet and Google Calendar.
I keep reading here abut Zapier. I really need to check into it. So far have not needed it.
@WillowMobileSystems I have used zapier solely for grabbing attachments from emails and storing them in a shared google drive. Other members on our team have used it to grab emails and create rows in a spreadsheet based on the content. It seems like a very powerful accessory tool.