How can I replace months by numbers?

  • grupovision
    Asked on July 7, 2016 at 4:48 PM

    I have some selection fields with "Special Option = Months" but need the mail is received to numbers.

    Ex.

    1. Select: January     Email = month_field: 1
    2. Select: February    email = month_field: 2

    I can do this?

  • David JotForm Support Manager
    Replied on July 7, 2016 at 7:31 PM

    It is not possible to set this up inside the field. However, you my consider the following workaround:

    1) Add a Form Calculation field which you will use to replace the month field in your notification:

    How can I replace months by numbers? Image 1 Screenshot 80

    2) Remove the special value of your Drop Down field, and add the options manually:

    How can I replace months by numbers? Image 2 Screenshot 91

    3) Assign to each option a value number: https://www.jotform.com/help/301-How-to-Assign-Calculation-Value 

    How can I replace months by numbers? Image 3 Screenshot 102

    4) Assign the Drop Down "months" field into the Form Calculation widget:

    How can I replace months by numbers? Image 4 Screenshot 113

    5) Edit your email notification to replace your Drop Down field for the Form Calculation field:

    How can I replace months by numbers? Image 5 Screenshot 124

    5) Submit your form:

    How can I replace months by numbers? Image 6 Screenshot 135

    Result:

    How can I replace months by numbers? Image 7 Screenshot 146

    Here is my demo version: https://form.jotform.com/61887281920968 

    You may clone it to inspect further: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    Hope this helps.

  • grupovision
    Replied on October 22, 2016 at 9:01 AM

    Has a problem with this results. Need represents numbers with two characters (January = 01)

    I tried adding zero to 1 to 9 months, but the result Mail shows without zero.

    The system collects the application needs two characters to recognize the data and process the request automatically.

    Thank you for your help!

  • Welvin Support Team Lead
    Replied on October 22, 2016 at 2:31 PM

    You can pass the value as a text and this should resolve the issue. In the calculation, hover and click your mouse on the field and make sure it should appear as A-Z:

    How can I replace months by numbers? Image 1 Screenshot 20

  • grupovision
    Replied on October 24, 2016 at 4:50 PM

    Welvin No find where can change to A-Z

    How can do it?

    How can I replace months by numbers? Image 1 Screenshot 20

  • Welvin Support Team Lead
    Replied on October 24, 2016 at 6:33 PM

    You are on the old layout. You can click the field (avail_start_month) to change its color and make it as a text. 

    If you to access the new layout, simply log out from your account then clear your cookies for Jotform before logging in again. 

  • grupovision
    Replied on October 26, 2016 at 3:47 PM

    Its Work

    Thank you Welvin!