Hello, everyone!
I created a template for ICS with the code below. The problem is that it sends the invitation to the ATTENDEES but does not create the invitation in the active user's calendar using the app.
The event is triggered by a change in a table record.
From the email attributes, I only fill the "To" field with a list of emails, excluding the email of the active user using the app.
In the invitation received by the ATTENDEES, the logged-in user's email appears as the organizer.
If I try to remove the ORGANIZER parameter or set the active user as an ATTENDEE, I get an error stating that it is not possible to modify the ORGANIZER.
I also tried fixing the ICS script without variables, and the problem remains the same.
In the monitor, the bot processes it normally.
Has anyone experienced this problem?
I wish you all a prosperous 2025.
Thank you very much for your help.
Here is the template:
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//AppSheet Inc//AppSheet
CALSCALE:GREGORIAN
METHOD:REQUEST
BEGIN:VTIMEZONE
TZID:America/Sao_Paulo
BEGIN:STANDARD
DTSTART:20240101T000000
TZOFFSETFROM:-0300
TZOFFSETTO:-0300
TZNAME:BRT
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
SUMMARY:Kickoff do projeto <<[Titulo]>>
UID:7c22491d-71cd-4c60-ae2e-3ffba6d89a5c
DTSTART;TZID=America/Sao_Paulo:<<TEXT([Kickoff], "YYYYMMDDTHHMMSS")>>
DTEND;TZID=America/Sao_Paulo:<<TEXT([Kickoff] + "001:30:00", "YYYYMMDDTHHMMSS")>>
DESCRIPTION:Nossa reuniรฃo de kickoff do evento <<[Titulo]>>
DTSTAMP:<<TEXT(NOW(), "YYYYMMDDTHHMMSSZ")>>
ORGANIZER;CN=<<USERNAME()>>:MAILTO:<<USEREMAIL()>>
<<Start:SELECT(Membros[ROW ID], AND(IN([Row ID], SELECT(Equipes[Intgrante], [Evento]=[_THISROW].[Row ID])), [email]<>USEREMAIL()))>>
ATTENDEE;CN=<<[Nome]>> <<[Sobrenome]>>;RSVP=TRUE:MAILTO:<<[email]>> <>
END:VEVENT
END:VCALENDAR
This is the executed ICS that arrives in the ATTENDEES' email:
BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//AppSheet Inc//AppSheet
CALSCALE:GREGORIAN
METHOD:REQUEST
BEGIN:VTIMEZONE
TZID:America/Sao_Paulo
BEGIN:STANDARD
DTSTART:20240101T000000
TZOFFSETFROM:-0300
TZOFFSETTO:-0300
TZNAME:BRT
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
SUMMARY:Kickoff do projeto Evento com Kickoff
UID:7c22491d-71cd-4c60-ae2e-3ffba6d89a5c
DTSTART;TZID=America/Sao_Paulo:20250102T150000
DTEND;TZID=America/Sao_Paulo:20250102T163000
DESCRIPTION:Nossa reuniรฃo de kickoff do evento Evento com Kickoff
DTSTAMP:20241229T121258Z
ORGANIZER;CN=:MAILTO:andre <PII Removed by Staff>
ATTENDEE;CN=Ricardo Cancela Duarte;RSVP=TRUE:MAILTO:alassef@gmail.com
ATTENDEE;CN=Carlos Brandรฃo;RSVP=TRUE:MAILTO:andre@go-bbx.com
END:VEVENT
END:VCALENDAR
Solved! Go to Solution.
Thanks for the clarification!
An ICS file is a description of a calendar event. It's up to the recipient of the file to "import" the file into their own calendar. There's no way you can inject an event into someone else's calendar.
As an alternative, you could use the app to manage a Google Calendar calendar and share that calendar with all potential participants.
User | Count |
---|---|
17 | |
14 | |
10 | |
7 | |
4 |