Submissions are showing fields not in the form

  • Profile Image
    nousernamesleft
    Asked on January 23, 2016 at 03:24 PM

    I used some of the address fields in a form & altered which one's would show up in the form. This looks fine in the form itself, but when it is filled in the submission database shows the unused fields? How can I get rid of these? Thanks.

  • Profile Image
    Jan
    Answered on January 24, 2016 at 02:48 AM

    Sorry but it is not recommended to use the address tool for that question. It is the reason why the other question or fields is showing in the email notification. 

    Pleae use the "Shrink" function if you want to achieve a 3 column element that has the product item, wholesale price and retail price.

     

    I created 1 text field and 2 text boxes. 

    After that, I use the "Shrink" function to make them small and aligned in 1 row.

     

    Let us know if you need any help. Thank you.

  • Profile Image
    nousernamesleft
    Answered on January 24, 2016 at 06:14 AM

    Thanks for your help. Unfortunately that creates another issue. The text box doesn't show up in the excel spreadsheet & therefor all the products are no longer labeled. This makes the data unusable as its no longer relevant to a particular product.

    I have tried a widget which allows you to create multiple text fields, but unfortunately it places all the info in one cell in excel which makes the functionality of a spreadsheet impossible.

    Is there a better way of creating a form where the data set is usable by a spreadsheet & properly labeled?

    Thanks.

     

     

  • Profile Image
    BDAVID
    Answered on January 24, 2016 at 12:15 PM

    What you can do is to implement what my colleague suggested, labeled the fields, and hide them with custom CSS, example:

    Spreadsheet:

    Here is my example form: https://form.jotform.com/60234538149961, this is the injected CSS applied: http://www.jotform.com/help/117-How-to-Inject-Custom-CSS-Codes

    #label_54,#label_55{

    display: none !important;

    }

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

     

  • Profile Image
    nousernamesleft
    Answered on January 24, 2016 at 01:15 PM

    Thanks, as I mentioned previously, this method is not then labeled correctly in excel submissions. As per your image.

    I don't understand what the URL cloning is about? or how it relates to this issue.

    What is required is either a labeled table or multiple fields that enter data into single cells that are labeled in excel. Thanks.