Discussions

 View Only
  • 1.  GCal Formula Help - Creating a calendar invite with attendees added

    Posted 02-22-2022 12:15
    Hi all, wondering if someone can help with this. 

    So we have some buttons in our apps that we use to quickly create an email. We use a combined text field that contains all of the email addresses and the button formula looks like this...

    "https://mail.google.com/mail/?view=cm&fs=1&to=" & [Emails of Project Team] & "&subject=" & URLEncode("Project Team Email: " &[Project Name] )

    This button opens a new gmail tab, adds all the email addresses into the "To" field and populates the subject line too]

    Now here's the question...

    Can we do the same thing for calendar invites? So could we have a button that opened a new google calendar tab, created a new event, populated the emails of the people into the "Attendees" and populated the event name with the project name.

    The date and time doesnt matter, the user can edit this. The point is we want to make it easier to create a calendar event with the project team

    Any thoughts or help would be appreciated

    Thanks

    ------------------------------
    Process Q
    ------------------------------


  • 2.  RE: GCal Formula Help - Creating a calendar invite with attendees added

    Posted 02-22-2022 12:59
    I don't know about adding attendees, but here is a way to generate the event (times are in GMT):

    http://www.google.com/calendar/event?action=TEMPLATE&dates=20220301T010000Z%2F20220316T180000Z&text=Event%20Title&location=Location&details=Description

    In a URL you generate, it would look like:
    URLEncode("http://www.google.com/calendar/event?action=TEMPLATE&dates="&[from date]&"T"&[From Time in GMT]&"Z%2F"&[To Date]&"T"&[To Time in GMT]&"Z&text="&[Event Name]&"&location="&[Event Location]&"&details="&[Event details])

    ------------------------------
    Edward Hefter
    www.Sutubra.com
    ------------------------------



  • 3.  RE: GCal Formula Help - Creating a calendar invite with attendees added

    Posted 02-22-2022 13:10
    Thanks for this Edward but the attendees really is the most important bit, otherwise it will be easier to give the users a "copy to clipboard" button for the emails and have them manually create the calendar event

    ------------------------------
    Process Q
    ------------------------------



  • 4.  RE: GCal Formula Help - Creating a calendar invite with attendees added

    Posted 02-22-2022 13:24
    Edited by Edward Hefter 02-22-2022 13:28
    Found it - use the &Add=

    URLEncode("http://www.google.com/calendar/event?action=TEMPLATE&dates="&[from date]&"T"&[From Time in GMT]&"Z%2F"&[To Date]&"T"&[To Time in GMT]&"Z&text="&[Event Name]&"&location="&[Event Location]&"&details="&[Event details]&"&Add="[E-Mail Addresses])


    More details on the URL can be found here - https://github.com/InteractionDesignFoundation/add-event-to-calendar-docs/blob/main/services/google.md
    ------------------------------
    Edward Hefter
    www.Sutubra.com
    ------------------------------