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

    Add submissions date with Timezone on email notification

    Asked by ssmediator on July 03, 2013 at 02:03 AM

    Creating a Notificaton email, there's a Submission ID field, what is that?

  • Profile Image

    Answered by ssmediator on July 03, 2013 at 02:06 AM

    Never mind, I see what that is!  But, I do have a related question ... can I include the Submission Date in Notification emails?  I don't see a field for it, so I'm sure how I would do it.

  • Profile Image
    JotForm Support

    Answered by EltonCris on July 03, 2013 at 03:01 AM

    Hi,

    To include date on email notification, simply use {DATE} tag. 

    Here's a complete guide: Using Dates in Email Templates

    Best Regards! 

  • Profile Image

    Answered by ssmediator on July 03, 2013 at 03:06 AM

    OK, so can I do it like this

    sent on {DATE:Date-US}

  • Profile Image
    JotForm Support

    Answered by EltonCris on July 03, 2013 at 03:11 AM

    @ ssmediator 

    Exactly! That should display date in this format: July 3, 2013 as seen on the guide.

    Thank you!

  • Profile Image

    Answered by ssmediator on July 03, 2013 at 03:19 AM

    OK, thank you!

  • Profile Image

    Answered by gori-mathew on July 03, 2013 at 04:53 AM

    You are welcome, do feel free to let us know if you need further assistance.

    Thanks!

  • Profile Image

    Answered by ssmediator on July 03, 2013 at 06:39 PM

    I did a test Notication and the date/time did not appear correctly. I read the info about the date tag, but I'm not sure where to input the string data.

    The date that appeared--that is not correct--was:

    Jul 3, 2013 at 6:27:09 PM

    That's not correct because it's the wrong time zone.  So where/how to I input the T Timezone abbreviation?

    I want the date/time to look like this: Jul 3, 2013 at 6:27:09 PM PST (or whatever the correct time zone is of the user.)

  • Profile Image

    Answered by ssmediator on July 03, 2013 at 06:42 PM

    I just saw this date/time info on another test Notification.

    Message Date: July000000WednesdayWednesday-1372890540rd<00ppm7 003113WednesdayAmerica/New_York="f2013731-0029183America/New_York: 0007pmWednesdayWednesday;">

    What's that about?

  • Profile Image

    Answered by khrisell on July 03, 2013 at 09:23 PM

    Hi,

    Did you follow the proper walk-through on adding date to your email notification?

    http://www.jotform.me/help/68-Using-Dates-in-Email-Templates

    Kindly let us know if you need further assistance.

    Thank you for using JotForm.

  • Profile Image

    Answered by ssmediator on July 03, 2013 at 09:32 PM

    I see that I am not being understood.

    As I said, I read the info about the date tag, but I'm not sure where to input the string data.

    The date that appeared--the one that is not correct--was:

    Jul 3, 2013 at 6:27:09 PM

    That's not correct because it's the wrong time zone.  So where/how to I input the T Timezone abbreviation?

    I want the date/time to look like this: Jul 3, 2013 at 6:27:09 PM PST (or whatever the correct time zone is of the user.)


    I need examples that include the format characters.  I tried this:

    {DATE:Full-US T}

    and this

    {submissionDate}

  • Profile Image
    JotForm Support

    Answered by EltonCris on July 04, 2013 at 01:02 AM

    @ssmediator

    Correct me if I'm wrong, what you just need is to include PST after the date/time? You can simply add that after the tag. Example:

    {DATE:Full-US} PST

    Note that the date/time generated with {DATE} is EST time zone based.

    Let us know if you have further questions. Thank you!

  • Profile Image

    Answered by ssmediator on July 04, 2013 at 03:29 AM

    Actually, I want the time zone of the user who submitted the form.  For example, the test Notification email I did shows east coast time zone even though I submitted it here in the Pacific time zone.

    I have temporarily added EDT to the date/time since it seems that the time reflected is east coast. But, what is the T for shown here: http://php.net/manual/en/function.date.php#function.date

    T Timezone abbreviation Examples: EST, MDT ...

    I just need an example of how to enter it.  Like I said, I tried  

    {DATE:Full-US T}

  • Profile Image
    JotForm Support

    Answered by EltonCris on July 04, 2013 at 07:47 AM

    @ssmediator

    If you'd like to get user's timezone, simply add Date/Time field to your form and enable default date/time. The time would be taken out from the user's computer, which means it is from their timezone. Date/Time Tool is under Quick Tools.

    {DATE:Full-US T}, this won't work unfortunately. The tags available on the guide are custom made as far as I know not the usual PHP date tags.

    Thank you!

  • Profile Image

    Answered by ssmediator on July 04, 2013 at 02:03 PM

    Thanks, but that's not what I need. As the title of this thread indicates, I want to Add submissions date on email notifications.

    The following text is on this page: http://www.jotform.me/help/68-Using-Dates-in-Email-Templates

    "If you want to format the date string you can do so by adding a parameter to the tag: {DATE:arg}. We have some predefined parameters as shown below but if you need more customized dates you can do it with standard PHP date formatting. Follow the link for more information about PHP date formatting."

    So, when I go to that page, the standard PHP date formatting, I find all the format codes, one of which is T for Timezone.

    So, what does the code look like if one wants to use the T for timezone? OR, maybe I need to use the O for Greenwich time.

    In any case, I just need to know what the input should look like.  I am assuming that those format codes can be used, since it was referenced on the Jotform Using Dates in Email Templates page.

    Since this {DATE:Full-US T} is the wrong, what is correct?  Where does the T go, or the O, or whatever code I choose from that list?

  • Profile Image
    JotForm Support

    Answered by jonathan on July 04, 2013 at 04:20 PM

    @ssmediator

    Hi, your setup on the date argument {DATE:Full-US T} was correct already. But unfortunatelly, there seems to be a bug on this, that is why it is not working on the email notification as you wanted to.

    You can check the details of the bug ticket here. I understand that this is not on high priority since there is a simpler way to fix it. So, the ticket was still there.

    As mentioned by EltonCris , I am in agreement that you add instead the date/time field on the form so that it can be included in the email notification

    You can easily inject CSS code to hide the date/time field on the form. A similar solution was used on this thread (please check at the bottom part of the thread)

    Hope this help. Please inform us if you need further assistance.

    Thanks.

  • Profile Image

    Answered by ssmediator on July 04, 2013 at 04:50 PM

    I didn't understand that EltonChris meant to hide the label. 

    I know you said that I can easily inject the code; but the thread you referenced has too many expamples and I am lost!  Can you just tell me how to hide the date/time field?  What is the CSS code?

  • Profile Image

    Answered by ssmediator on July 04, 2013 at 05:13 PM

    I just did the date/time field in my form and then did a notification email with that field and it's fine!  Now, if I could just figure out how to hide the field in my form--please help me with that! 

    My workding doc form: 31837087003148

  • Profile Image
    JotForm Support

    Answered by jonathan on July 04, 2013 at 05:24 PM

    Hi,

    Please inject this CSS code in your form to hide the date/time field.

    #id_19{display:none;}

    Inform us if this does not work.

    Thanks.

  • Profile Image

    Answered by ssmediator on July 04, 2013 at 06:00 PM

    I hoped it would be something that simple!  Thank you!!

    One more thing, though, if I may: that code has caused that field to be hidden on my Edit Form page too.  Is that normal?

    p.s. The examples page shows us what a code might look lke and where/how to input it, but who knows what the exact text is for the exact form in question--not I.  All I know is that a CSS code usually has a { in it, and maybe a field ID in it.  Maybe a more comprehensive example page could be available so that we don't have to ask every time. 

    For example, it could be something like this:

    to hide a field, do this : #XX{display:none;} where XX is, input your field's ID.

    Anyway, that's my 2-cent suggestion.

  • Profile Image
    JotForm Support

    Answered by jonathan on July 04, 2013 at 06:10 PM

    Hi,

    One more thing, though, if I may: that code has caused that field to be hidden on my Edit Form page too.  Is that normal?

    Yes. This is normal. The CSS code will immediately take effect even while creating on the form builder.

    I check the live form  http://www.jotform.us/form/31837087003148 and it looks good already.

    --

    on the P.S.

    sorry but I was not able understand properly what you meant. Were you perhaps refering to the article guide How-to-Inject-Custom-CSS-Codes ? You mean there should be a correction?

    Kindly point out the correction that you suggest, so we can review. =) 

    Thanks!

     

  • Profile Image
    JotForm Support

    Answered by jonathan on July 04, 2013 at 06:10 PM

    Hi,

    One more thing, though, if I may: that code has caused that field to be hidden on my Edit Form page too.  Is that normal?

    Yes. This is normal. The CSS code will immediately take effect even while creating on the form builder.

    I check the live form  http://www.jotform.us/form/31837087003148 and it looks good already.

    --

    on the P.S.

    sorry but I was not able understand properly what you meant. Were you perhaps refering to the article guide How-to-Inject-Custom-CSS-Codes ? You mean there should be a correction?

    Kindly point out the correction that you suggest, so we can review. =) 

    Thanks!

     

  • Profile Image

    Answered by ssmediator on July 04, 2013 at 06:16 PM

    Oh, no, there's no correction. I was just suggesting that a more comprehensive example page could be available so that we don't have to ask every time. Unless there is one that I don't know about.

    If not, as I said, it could be something like this:

    to hide a field, do this : #XX{display:none;} where XX is, input your field's ID.

  • Profile Image
    JotForm Support

    Answered by jonathan on July 04, 2013 at 06:23 PM

    Well, you are correct! =) That is actually a better idea.

    I will try to update the article guide asap.

    --

    Just to give you a bit on info, in the current guide, the sample CSS code was using the class name of the fields instead of the id# of a field.

    Example, when you use .form-textbox class, the CSS code will affect ALL the textbox fields type.

    So, if you want to apply the CSS only to a particular field, you will use the ID# of the field instead. Like in your test form, the #id_19 is the exact date/time field we want to apply the CSS code.

     

    best regards,

  • Profile Image

    Answered by ssmediator on July 04, 2013 at 06:40 PM

    I see. Although, my knowledge in this area is so small that I wouldn't even to use .form-textbox or how/when to use it. (I don't know the class names of fields.)

    So, with that page you'll work on, it could also include something like:
    Field class names:
    for text boxes, this is the code: .form-textbox
    for xxxxxxxx, this is the code: xxxxxxxxx
    And so on.
    Thanks again!

  • Profile Image

    Answered by ssmediator on July 05, 2013 at 04:37 PM

    Another question, if I may: can the Date/Time field be changed to look like this instead?

    Jul 05 2013

    If so, how?

  • Profile Image
    JotForm Support

    Answered by EltonCris on July 05, 2013 at 07:37 PM

    Hi,

    Here's a visual guide on how to get field ID and it's class. For more details on it's syntax, please refer to this guide: http://www.w3schools.com/css/css_id_class.asp. You can inpsect all your form fields to get it's ID and class name, you can do this when you use Chrome or Firefox or any browser that has inspect element feature.

    Regarding on your second question, that's not possible in the form builder unfortunately. You can achieved that by modifying the calender.js script when you download your form's complete full source code. How to get your Form Source Code.

    Thanks!

  • Profile Image

    Answered by ssmediator on July 05, 2013 at 08:50 PM

    The date/time field on my form is hidden, so I can't right click it.  And even if I do figure out what field(s) need to be changed, I don't know what to do.

    In my test form, 31857554812864, I see this

    value="07" which I believe is the month; but I don't know how to get it to instead show Jul

    I changed the 07 to Jul, but the month still showed as 07

    I often use the w3schools website, but that page shows nothing about month fields, or how to change it from numeric, 07, to alpha Jul

    So, is it possible to make the change I asked about?  If so, how do I do it?

    BTW, I did find the following on the w3schools site, but I have no idea where to input or if it's even the correct thing to do for my form.

    Return the name of the month (not just a number):

    var d=new Date();
    var month=new Array();
    month[0]="January";
    month[1]="February";
    month[2]="March";
    month[3]="April";
    month[4]="May";
    month[5]="June";
    month[6]="July";
    month[7]="August";
    month[8]="September";
    month[9]="October";
    month[10]="November";
    month[11]="December";
    var n = month[d.getMonth()];
  • Profile Image

    Answered by dinesh-it on July 06, 2013 at 06:47 AM

    You can Find the Field ID's By Viewing the Page Source of your form.

    Right click on your form and Select View Page Source. Now You can Search and Find the Field ID's. The Simple way is Use Ctrl + F (Find Shortcut) and Type the name of the Field. So Now You can easily find out the Field ID's.

    So In your Form it is there as shown below

     

    You have to use the Form Full Source Code to Add your own Javascript Code.

    Thank you.

  • Profile Image

    Answered by ssmediator on July 06, 2013 at 04:02 PM

    Well, I did find the field ID, trouble is I don't know what to do with it!  In other words, I don't know how to make is say: July (or August, or September, and so on) instead of 07
    Do you know what I need to do?

  • Profile Image
    JotForm Support

    Answered by EltonCris on July 06, 2013 at 11:21 PM

     

    @ssmediator

    We will provide you solutions about this on the other thread later today.

    This thread is getting longer and it's not sticking to the main topic, we'll create a new thread for you with the workaround to achieve this.

    Thanks!

     
  • Profile Image
    JotForm Support

    Answered by EltonCris on July 07, 2013 at 10:50 AM

    @ssmediator

    You can find my workaroud on this thread: http://www.jotform.me/answers/238588

    Thanks!

  • Profile Image

    Answered by ceu.csupomona on February 20, 2014 at 07:04 PM

    Hi, Sorry I dont know if i should post my question here about the DATE command. I did {DATE:Full-US} but its showing up 3 hours ahead of the time. Is it going base of of EST time? 

    this is what i get with the command

    Feb 20, 2014 at 7:01:20 PM

    but the real time is actually 4:01:20 PM

  • Profile Image
    JotForm Support

    Answered by BDAVID on February 20, 2014 at 08:32 PM

    Please open a new thread, and provide as much details as you can, like the URL of you form. We will be glad to assist you.