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

    Date and Time integration with salesforce.

    Asked by DaveElms22 on February 15, 2017 at 08:07 PM

    Having trouble merging the "Time" for your date and time field. It just sends 2:30 AM every time. Tried changing it from AM/PM to 24 hour but same results. Any ideas?

    Page URL:
    https://form.jotform.com/70456321055146

    Screenshot
  • Profile Image
    JotForm Support

    Answered by Chriistian on February 16, 2017 at 03:25 AM

    Sorry for the inconvenience.

    I checked your form and I noticed that you are using a one Date Picker with enabled time field.  Can you please try to separate it using Date Picker and Time field?

     

     

    Or please also try to use simple custom text boxes to capture the dates mentioned here in this guide: Mastering SalesForce with JotForm.

    If issue still persists, please let us know.
    Regards

  • Profile Image

    Answered by DaveElms22 on February 16, 2017 at 04:51 PM

    Hi Chriistian,

    I would be willing to separate the date and time into separate fields but salesforce only has Date or Date/Time, it does not have Time by itself. According to Answer 802018 shoeman was able to pass Date/time to salesforce. Any ideas why time is being sent with incorrect values or any other suggestions?

  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 16, 2017 at 07:33 PM

    I have tested with a date time field in SalesForce and noticed the data is going through properly, here're some screenshots about it. 

    JotForm: 

    SalesForce:

    I have set up the date format on my form based on this link: https://help.salesforce.com/articleView?id=000004680&type=1 

    Time is being passed without any problem on my end, could you please try setting up your date time field the same way and re-integrate with your SalesForce account again. 

    I just simple added a date time field in SalesForce and mapped it from Jotform, you could also try doing the same. 

    Please, let us know how it goes. 

  • Profile Image

    Answered by DaveElms22 on February 16, 2017 at 10:31 PM

    Changed the date date format as you suggested. Pushed 3 examples through. Updated time zones in both salesforce and Jotform. Each time I submitted time as 4:30 PM and salesforce imported at 9:30 AM. Any other suggestions?

  • Profile Image
    JotForm Support

    Answered by Chriistian on February 17, 2017 at 12:23 AM

    I'm currently checking the issue. Please allow me some time to further investigate. I'll get back once I've found results.

    Regards

  • Profile Image

    Answered by DaveElms22 on February 20, 2017 at 10:02 AM

    I had changed the time zone at the org level, but changing it at the user level to GMT fixed the problem. Thanks!