How to get submission date as variable in the form

  • Profile Image
    yaroslavpaz
    Asked on May 28, 2020 at 05:27 PM

    hi guys


    is there a way to  get submission date as variable in the form?

    the problem actual date is pushing from cellphone and some times it just puts the date of yesterday and not the actual gmt-4

  • Profile Image
    Mike
    Answered on May 28, 2020 at 08:45 PM

    Please kindly provide a bit more information on your inquiry. Where exactly would you like to see the submission date (e.g. form Inbox, PDF document, form Submissions, somewhere else)? This may also help if you can show where you see the wrong date.

  • Profile Image
    yaroslavpaz
    Answered on May 28, 2020 at 09:54 PM

     form Submissions

    because on submission date it takes the server date

    while on date value (fecha) the cellphone and sometimes its from yesterday

    so I want to calculate Fecha from submission date:

    https://eu.jotform.com/build/201305024780039

  • Profile Image
    BJoanna
    Answered on May 29, 2020 at 02:37 AM

    You need to change the TimeZone on the account settings page. It is currently set to America/La_Paz (GMT-4). 

    1590734111zone.PNG

    How to Change Submission Date to a Different Format and Timezone

  • Profile Image
    yaroslavpaz
    Answered on May 29, 2020 at 06:19 AM

    yes, I have it already.

    But the current date widget is getting some times yesterday:

    https://www.dropbox.com/s/74icgpvnx8btjd5/Screenshot%202020-05-29%2006.16.23.png?dl=0


    Here responses: https://www.dropbox.com/s/12lts4iq5jqhkql/Screenshot%202020-05-29%2006.17.53.png?dl=0


    All forms are filled in Bolivia, it seems a cellphone related issues, how can we fix it? submission date is always correct, if it could be passed as variable to my date. It could solve the problem.

  • Profile Image
    Bojan_J
    Answered on May 29, 2020 at 08:35 AM

    Thank you for your reply.

    I have tested the form, but unfortunately, I was not able to replicate the problem.

    Can you please try to use another field, for example, a Date picker, and let us know if the problem is still present?

    Please note that by removing the existing field from the form, you will also remove all existing data from that field. 

    Let us know if the problem is present in this field as well.

    Thank you for your cooperation. 

  • Profile Image
    yaroslavpaz
    Answered on May 29, 2020 at 09:12 AM

    nope that doesnt select hidden the date of today: https://www.dropbox.com/s/sw0g1mf0j9ln5nn/Screenshot%202020-05-29%2009.12.22.png?dl=0

  • Profile Image
    Sonnyfer
    Answered on May 29, 2020 at 09:43 AM

    I agree with you that it may have something to do with Mobile's timezone.

    Submission Date follows your account's timezone while the Date Picker captures the machine's. Can you please share with us the timezone set on your mobile so we can try replicating the same on our end?

    Alternatively, you can create a short video of submission, upload it to any free cloud storage (eg. Google Drive, Dropbox), and then share the link for us to view it.

    Looking forward to your response.

  • Profile Image
    yaroslavpaz
    Answered on May 29, 2020 at 09:55 AM

    I want date picker to capture account time zone

    how do we capture it in a variable apart of submission date?

  • Profile Image
    Mianala
    Answered on May 29, 2020 at 10:57 AM

    Hello, I am looking into this possibility. I will get back to you shortly.

  • Profile Image
    Mianala
    Answered on May 29, 2020 at 11:19 AM

    Unfortunately, it is not possible to get the time difference between your timezone and the user's as a column in the submissions. You can get the difference later using excel formula, or if you are embedding your form with the full source code, you can use JavaScript's getTimeZoneOffset function.

    Getting the full source-code: https://www.jotform.com/help/104-How-to-get-the-Full-Source-Code-of-your-Form

    JS timezone: https://www.w3schools.com/jsref/jsref_gettimezoneoffset.asp 

    Let us know if you need further assistance.  

  • Profile Image
    yaroslavpaz
    Answered on June 12, 2020 at 12:20 PM

    it still nothing and not very good way of getting date from account instead of cellphone cause im getting random dates

    can you scale it to development please?

    it should be just a simple setup setting 

  • Profile Image
    Bojan_J
    Answered on June 12, 2020 at 01:31 PM

    Greetings and thank you for your reply.

    If you wish to capture your user's time zone, you are able to use the Hidden Box widget. This widget will allow you to see what is the timezone of the user who filled the form. You can click here to learn more about this.

    However, this will not allow you to use calculation with the time, you are only able to see the timezone.

    Please let us know if this solution will work for you.