Attached herein is a public example app showing how to use an ICS template to send a calendar event email to recipients. A few comments in no particular order:
online help for this feature: https://help.appsheet.com/en/articles/3568441-adding-a-calendar-ics-attachment-to-an-email
This feature has just dropped, so apologies in advance for any errors or omissions. And, feedback most welcome here!
The example app attached here has a parent-child relationship: the parent is the calendar entry, and the children are the email recipients. Here is the app link:
- In the workflow, we will generate an email for any ADDS or UPDATES to a calendar event. The “TO” line is set to:
(i.e. the children of the parent calendar invite item)
The subject line is <<[Subject]>>. The start and end times are the start and end fields. I have not yet tackled timezones so the defaut behavior is “current timezone” of the client device.
The ICS template is a plain text file that ends in .ics - google sheets (and probably one drive) is somewhat picky about this. As the help article states, you will want to download, edit, and then re-upload the ICS content file with great care. AppSheet will informatively throw an error if you make a mistake during this part of the process.
Lastly, ICS files have a UID field, this is documented somewhat vaguely in the original ietf RFP:
which was written in 1998 and last updated in 2009. Lolz… We believe that this UID field does need to support a pretty broad definition of “uniqueness” - in the example we have created a virtual calculation field whose definition is:
(somewhat of a hack, but it’s getting the job done)
Here are the full contents of the ICS file used in this example:
X-COMMENT: See https://icalendar.org/validator.html
SUMMARY:Meeting about <<[Subject]>>
DESCRIPTION:This is an invitation to a meeting about <<[Subject]>>
Let us know here if you have any questions or feedback. Thank you!