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

    Submissions are showing fields not in the form

    Asked by nousernamesleft 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.

    unused fields address shrink address field submissions
  • Profile Image
    JotForm Support

    Answered by Jan 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

    Answered by nousernamesleft 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
    JotForm Support

    Answered by BDAVID 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

    Answered by nousernamesleft 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.