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
@Ramiro_Ortiz
What data you want to insert to Google Calendar and in what way do you want to insert it? Can you elaborate?
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.
Maybe this can help you
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!.
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"
)
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
13 |