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 can i do String manipulation using condition?

    Asked by viskar on December 04, 2015 at 04:47 AM

    Example, i have created a textbox with a filed  call NRIC.

    The format for this field is xxxxxx-yy-zzzz.

     

    Example : 981201-12-5566

    I want to extract the above data separately like, 

    First 6 characters represent Dirth Of Birth in reverse manner. For the above data 98 is year, 12 is month, 01 is date. once someone fill up the above NRIC filed, i want to automatically fill up Dirth of Birth field with the given information.

     

    Is this archiveable ? 

    Page URL:
    https://form.jotform.me/53338118430450

    Screenshot
    textbox fill call substring
  • Profile Image

    Answered by victor on December 04, 2015 at 07:29 AM

    You may try using the substring widget. Using this and a condition to update the value of the date might help you out.

    You can use 3 different substring fields, one for the month, day and year. Once this gets the value you can update it to the date field with the condition update value.

    Please let us know if this helps.

  • Profile Image

    Answered by viskar on December 16, 2015 at 07:51 PM

    really helps, thank you so much.

    Right now the value is being assigned to text box in D.0.B field. Can i do the same for calender?

  • Profile Image
    JotForm Support

    Answered by jonathan on December 16, 2015 at 09:01 PM

    Hi,

    Can i do the same for calender?

    Please describe more so we can check for a solution. Which calendar on where you referring to?

    I tried looking for it on your jotform http://www.jotform.com/53338118430450 but so far I could not find it.

    Thanks.