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 auto populate a text field with a substring of another field?

    Asked by Hfplus on June 19, 2015 at 10:23 AM

    We have a text field where the input might be: 004S01234567

    We want to auto populate another text field with everything past the "S" in the first text field. Results being: 01234567.

    We are able to do this in excel as a formula like: =RIGHT(TEXT,8) and this would return the 8 characters starting from the right.

    How can this be done in a form?

     

    Thank you,

    HFplus

    text field another first substring
  • Profile Image
    JotForm Support

    Answered by Boris on June 19, 2015 at 12:19 PM

    You can do that by using our Substring widget (manual: How-to-Add-a-Widget-to-your-Form)

    I have set up a small demo of it, here:

    http://form.jotformpro.com/form/51694748956980

    The settings of the Substring widget would be as follows:

    1 = which fields has the full code
    2 = which character to start with, start after 4th
    3 = which character to end with, we put a number that we know is larger than the secret code will be, in this case 99

    Now, if you want to forward this (sub)string from the widget to another field of the form, you can use Conditional-Logic to update that fields value from this widget.

    Please let us know if you need further assistance.