Creating a calendar file with dynamic dates/times | Community
Skip to main content
Dan_Stevens_
Dan_Stevens_
Level 10
Jul 28, 2015 2:07 PM UTC
Question

Creating a calendar file with dynamic dates/times

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?

    15 replies

    Edward_Unthank_
    Edward_Unthank_
    Level 7
    Jul 29, 2015 5:12 PM UTC

    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

    Translate
    SanfordWhiteman
    SanfordWhiteman
    Level 10
    Jul 28, 2015 4:16 PM UTC

    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.

    Translate
    Shashank_Sharma
    Shashank_Sharma
    Level 2
    Dec 26, 2017 3:25 PM UTC

    @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

    Translate
    SanfordWhiteman
    SanfordWhiteman
    Level 10
    Dec 26, 2017 5:43 PM UTC

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

    Translate
      Josh_Hill13
      Josh_Hill13
      Level 10
      Jul 28, 2015 3:35 PM UTC

      No.

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

      Translate
      Dan_Stevens_
      Dan_Stevens_Author
      Level 10
      Jul 28, 2015 3:38 PM UTC

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

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...