Creating a calendar file with dynamic dates/times | Community
Skip to main content
Dan_Stevens_
Dan_Stevens_
Level 10
July 28, 2015
Question

Creating a calendar file with dynamic dates/times

  • July 28, 2015
  • 3 replies
  • 7517 views

We have an event that will allow the registrant to select a specific date and time for which to meet with us.  We'd like to include these values within the calendar reminder that gets sent in the confirmation email.  Is it possible to include dynamic dates/times in a calendar file?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    3 replies

    Josh_Hill13
    Josh_Hill13
    Level 10
    July 28, 2015

    No.

    Different webinars will require different programs anyway, so you should set the respective ICS in each PRogram as a  local token.

    Dan_Stevens_
    Dan_Stevens_Author
    Level 10
    July 28, 2015

    Thanks for confirming.  These aren't webinars but rather options to meet our sales executives during an in-person event.

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    July 28, 2015

    Dan, I have a dynamic ICS file generator based on query params.  A robust single-event ICS file is still ~800K including both full field names and their values, so the URL is usable, albeit ugly (but of course you'd hide it with a pretty link).  Something to think  about.  DM me if you want to hear more.

    Shashank_Sharma
    Shashank_Sharma
    Level 2
    December 26, 2017

    @Sanford Whiteman​ - We're also trying to do something similar. Basically, we are giving option on our webinar registration form for people to select different session dates. So, looking to include the calendar file with the session date they selected on the reg form. We're looking to scale our webinars, so the ability to create dynamic calendar file will be really helpful. Can you please guide me on how to generate dynamic calendar file to be added in the confirmation email?

    Thanks,

    Shashank Sharma

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    December 26, 2017

    Check out these blog posts on Agical: http://blog.teknkl.com/tag/agical/

      Edward_Unthank_
      Edward_Unthank_
      Level 7
      July 29, 2015

      If you want to use a Google Calendar link, I wrote up an article a long while ago on how to do this with program tokens. You can pretty easily change those tokens to be lead tokens. They could be populated through the original form via picklist that inputs calendar-friendly format, and then you can put that link behind a pretty button.

      So if you were picking a "choose a good time of day to meet," that could be something like:

      • 8:00-8:30am PDT | 080000
      • 8:30-9:00am PDT | 090000
      • 9:30-10:00am PDT | 093000
      • [etc for picklist options and actual values]

      Then you could combine that with Munchtions for both date math (ADD_TO_DATE) as well as date formatting (FORMAT). These could change the lead values and format in a way that would be digestable for the Google Calendar functionality.

      Trigger: Lead fills out "calendar setting form."

      Flow Step 1: Change data value "Date - Meeting_Date = ##ADD_TO_DATE({{system.date}}, 7,"days")##"

      Flow Step 2: Change data value "Date - Meeting_Date = ##FORMAT({{lead.Date - Meeting_Date}},"Ymd")##"

      That would spit out +7 days from the current system date (when the trigger is activated) in YYYYMMDD format.

      Use those lead tokens instead of program tokens, and you have a dynamic GCal link based on the lead! Or, Sanford and I are working on creating a dynamic ICS generator where you could use the same lead or program tokens.

      Cheers,

      Edward Unthank | Founder, Etumos

      Terms & ConditionsAccessibility statement

      Loading footer...