Field name mapping

  • Profile Image
    SimplyWellbeing
    Asked 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
    NeilVicente
    Answered 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
    SimplyWellbeing
    Answered 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
    NeilVicente
    Answered 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.