Maniupulating Information in Data & Hidden Questions

  • Profile Image
    Scioto_Hills_Camp
    Asked on October 29, 2013 at 04:46 PM

    Hello,

     

    I was wondering if there is any way to manipulate how the data is presented in the csv or excell file before it is opened in excel.  (I know the data can be manipulated once opened in excell)

     

    I also was wondering if there is any way to put hidden questions on the forms.  I noticed there was one hidden question possibility in form builder, but wondering if there were any other options as far as a hidden drop down box question, or a hidden bullet point question, or a hidden text box, or a hidden yes or no question.

     

    Thank you for your help

    Jade

    You can contact me back at grow@sciotohills.com

  • Profile Image
    Welvin
    Answered on October 29, 2013 at 05:10 PM

    Hi Jade,

    You can edit a form submission by going to your form submissions page;

    From your form submission page, you can deselect questions NOT to show it in the excel or csv report:

    Settings > Fields  >Select/Deselect:

    We would be happy to provide you any further information if you can expand your question on how you would like to manipulate the form data.

     

    Unfortunately, we do not have any other hidden fields from our form builder. We can give you a workaround but would request you to open this on a separate thread. You can create a new thread here: https://www.jotform.com/answers/answer.php?.

    Thank you!