Link a date to google calendar so it is added to the calendar

AppSheet AppSheet Q&A
1

I have a google spredsheet as data. I need to be able to insert data to a google calendar, is there a way to do this?? Thanks

2

@Ramiro_Ortiz
What data you want to insert to Google Calendar and in what way do you want to insert it? Can you elaborate?

3

i’d like to insert the name of a patient and the date of surgery to the calendar. My idea is once u complete all the patient’s data it adds the date and name to the calendar.

4

Maybe this can help you

[Enabling app users to add Google Calendar events from your app](https://community.appsheet.com/t/adding-google-calendar-events-from-your-apps/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 …

2 Likes
5

I have this problem: Expression ‘https://www.google.com/calendar/render?action=TEMPLATE&text=[antec]&dates=[fecha qx]&details=[interconsultas]&location=[plan]&sf=true&output=xml’ could not be parsed due to exception: #VALUE!.

6

You cannot enter raw URLs as an expression. Instead, you have to construct it as a Text value:

CONCATENATE(
  "https://www.google.com/calendar/render?action=TEMPLATE&text=",
  ENCODEURL([antec]),
  "&dates=",
  ENCODEURL([fecha qx]),
  "&details=",
  ENCODEURL([interconsultas]),
  "&location=",
  ENCODEURL([plan]),
  "&sf=true&output=xml"
)