Based on user inputs, I want them to be able to create recurring events that they can add to their native mobile calendar. Is this possible with glide?
I was literally about to ask the same question
At this point in the evolution of Glide that is not something that can be done. There is no real back end calculation logic that would make this possible now in Glide. Yes it can do math and create virtual columns of data based on this math but not actually create new rows of data. That leaves any logic back in Google Sheets. Maybe someone has figured out a way to do this with just sheet formulas but I think it would be difficult and have limitations. I can think of a few options but each would require some Google script code to pull off.
First would be to send all created calendar events to a Google calendar and let the Google calendar deal with these reoccurring events. The resultant events from the Google calendar would be imported back into a sheet which would be the one displayed in the app. I have not done the export myself yet, but do import nightly from a Google calendar into one of my Glide apps. The export logic wouldn’t be that much different from the import and there are a lot of cross functions available to connect the sheet to the calendar.
Thanks, George. Do you know if this is in the Glide roadmap for any time soon?
Sorry I have no idea if it is or not. If it is however I would believe it is at the bottom of the list, but again I’m just speculating.
Hi guys. I have been hoping that 2-way calendar sync is on the roadmap as it’s a key feature I need.
Abix - Would you be able to create a video of how you have structured your spreadsheet/app as your solution looks like a potential work around for now. I haven’t used columns before.
With the app that I have that needs 2-way sync I know I have all of the details available within the app. I.e.
User email address
User Google calendar URL (you can get this from within Google Calendars to allow input.
Appointment UID (from Glide)
Appointment start time
I am sure a piece of Google script could be written to be running in the background to sync new and any changes but I have no idea where to start as I’m not a programmer (hence using Glide apps!).
Would you be able to share some more details of how you achieve the import/export.
Assume I know nothing about programming and you’d be near my level of understanding!
I just did a Google search and found this article https://opensource.com/article/19/1/automate-calendar. When I did a pull from a Google Calendar to a sheet I googled it and found some code that I modified.
Sharing more detail about code to someone who has no understanding of programming is kind of an oxymoron. Coding is all about details, which would not be understood by someone how has no knowledge. In any event take a look at the article and see if they do a good or bad job of dumbing it down to understand. If it’s too deep, do another search and keep looking at examples. I’m sure there are 100’s if not thousands of them. Good luck!
I was just thinking of this the other day too. Using Zapier, managed to at least import new calendar events from Google calendars to sheets (for all future events)…but if the repeating event is canceled the sheet still retains the rows that were created.
Thanks George. I had found the same article actually and yes - It’s beyond me!
I’ll keep digging.