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

    Field name mapping

    Asked by SimplyWellbeing on January 17, 2012 at 08:44 PM

    Hi,

     

    Like the product a lot. I have to use the same name for many matrix inputs, namely examples. This makes for a very confused spreadsheet, with many heading columns being example. Could we have a facility to map your derived field names to ones of our choosing?

    Thanks

    Andrew

  • Profile Image
    JotForm Support

    Answered by NeilVicente on January 17, 2012 at 11:43 PM

    Hi Andrew,

    The answer to your question is no. Submission reports take the name of the field as the column name in exported spreadsheets. There is no way you can change this.

    I suggest that you used a slightly different variation of "Examples" as your matrix field names. For example, Examples 1.1, Examples 1.2, etc.

  • Profile Image

    Answered by SimplyWellbeing on January 18, 2012 at 05:00 AM

    Thanks for your response. I knew the current answer was no, but is this not worth while considering for a future release?

    So far a lot of the energy of JotForm has been focused on the very attractive and easy to use front end but little on helping us use the data captured? With a large form (my forms will have potentially over 100 fields) it is pretty hard work to tidy up the sheet produced. If I tidy the headings bu copy/paste then this must be done frequently as new data arrives. If you then need to process that data in any way JotForm doesn't seem to help - unless I am missing something?

    Forcing the use of meaningful field names in order to help me read the speadsheets doesn't make sense, my users get no benefits from seeing 1.1 etc. It would seem a fairly trivial piece of coding to offer this mapping and I imagine would be very helpful for many users. I would simply fill in a JotForm table such as:

    example ---> ds1-ex

    do you find it difficult to concentrate or mundane tasks? ---> ds1-1

    is it difficult to start new tasks or complete existing ones? ---> ds1-2 

    other --> ds1-other

    example ---> ds2-ex

    are you easily distracted when by noises and people?  ---> ds2-1

    do you often act quickly and without considering the consequences? ---> ds2-2 

    other --> ds2-other

     

    Thanks for your help.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on January 18, 2012 at 10:53 AM

    Andrew,

    I will have your suggestion added to our wishlist. As with any other suggestions/requests though, we cannot guarantee a definite time as to when it will be implemented, if at all.

    In the meantime, try this workaround I came up with:

    1.  Add a single character prefix to your "Examples" field names. Do not add a space. Ex. "aExamples", "bExamples", "cExamples"

    2.  Inject this custom css code to your form:

    #label_12::first-letter {
    color:white;
    }
    #label_13::first-letter {
    color:white;
    }#label_24::first-letter {
    color:white;
    }
    #label_32::first-letter {
    color:white;
    }
    #label_37::first-letter {
    color:white;
    }
    #label_42::first-letter {
    color:white;
    }
    #label_49::first-letter {
    color:white;
    }
    #label_52::first-letter {
    color:white;
    }
    #label_61::first-letter {
    color:white;
    }
    #label_62::first-letter {
    color:white;
    }#label_71::first-letter {
    color:white;
    }
    #label_72::first-letter {
    color:white;
    }

    3.  Save your form

    What happens is the first letter of your "Examples" field name becomes hidden so that your users see all field names as "Examples", while on the backend, the field names are varied.

    View this cloned form to see this workaround in action.