What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How to change date format for output into Google Calendar through Zappier

    Asked by klausdyba on February 04, 2017 at 03:12 AM

    Hi! I have a little issue. I use zappier to add my form infos to google calendar. I use the european format DD/MM/YYYY

     

    sent to google calendar by zappier changes it to MM/DD/YYYY so a date on the 4th february 2017 is shown on the 2nd april 2017. 

     

    I know i can transform the date format in zapier, but then I need another step and have to pay 20$ instead of 0$ just for this step.

     

    Strange question, but can i somehow transform by formcalculator the input (dd/mm/yyyy) date to a text string (mm/dd/yyyy)? Then zapier would read it correct, but my customers still could use the european calendar format.

    I need some text field that reads out the day, month, year and format it in a way i need it.

     

    Klaus

     

     

     

    Page URL:
    http://www.loftstudiocologne.com/booking2

  • Profile Image
    JotForm Support

    Answered by Boris on February 04, 2017 at 06:23 AM

    The easiest way to achieve your requirement is to add another DateTime field to your JotForm form, which can be hidden so that it does not confuse your users.

    So you would have a visible DateTime with DD-MM-YYYY format for your users to select a date.

    You would have a second DateTime field with MM-DD-YYYY format. You can set this field as hidden from its advanced settings.

    You would pass the date from the first field to the second field by using our insert conditions:

    https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-Field-Using-Conditional-Logic

    When your users select their DD-MM-YYYY date, the other field would automatically get filled out by the same date in MM-DD-YYYY format:

    With this done, you can simply use that hidden DateTime field in your Zapier integration for Google Calendar. Please try it out, and let us know should you need further assistance or run into any snags along the way. We'll be happy to help.

  • Profile Image

    Answered by klaus on February 04, 2017 at 06:47 AM

    That's exactly what i am looking for! But I think i got the calculation wrong...

     

  • Profile Image

    Answered by klausdyba on February 04, 2017 at 07:35 AM

    Got it! i used a wrong field for input!!!!

     

    Thank you! I will let you know if it works with zapier and if everything comes trough in my google calendar

  • Profile Image

    Answered by klausdyba on February 04, 2017 at 07:53 AM

    It works!!!!! Thank you sooo much!! The best support!!

  • Profile Image
    JotForm Support

    Answered by Boris on February 04, 2017 at 09:33 AM

    We're glad to hear that, based on the tests we have conducted this seems to be working fine with Zapier integrations. Thank you for confirming it works to your satisfaction as well.

    Should you need assistance with anything else, please don't hesitate opening another support thread in our forum anytime: https://www.jotform.com/contact

    Cheers!