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

    Add additional column in Spreadsheet

    Asked by rmcorr on July 05, 2015 at 10:28 AM

    can I add a column to the "submissions" spreadsheet for our post-receipt notes? Or does this have to be done by adding a hidden field to the form ?

    Page URL:
    www.njticservice.com/titleproblemclaimform

    Submissions spreadsheet
  • Profile Image
    JotForm Support

    Answered by BJoanna on July 05, 2015 at 11:15 AM

    Unfortunately if you add additional column to your submissions spreadsheet after generating submissions next time that column will be lost. 

    To achieve that column is generated and that data added to that column are not lost you would need to add hidden fields inside of your form.

    Hidden field will not be visible inside of your form, but you would have them inside of your excel report and then you can add your notes inside of excel report.

    Hope this will help. Let us know if you need further assistance.

  • Profile Image

    Answered by rmcorr on July 05, 2015 at 01:00 PM

    Thank you.

    I ave done that and the columns show up on the list of Submissions but I can't enter any notes in the column.   

    I was able to go to the received form and enter notes in the hidden text boxes using the "edit" function but when the form with the notes is saved it generates a new notification email.

    Is there any way to enter data directly on the submissions spreadsheet without editing the form?  We use the notes fields to add a number to the request and to make status notes as we work on the request.

    Thank you again!

  • Profile Image
    JotForm Support

    Answered by jonathan on July 05, 2015 at 01:35 PM

    Hi,

    Since the new question is not anymore about the original topic I have move it here 

    http://www.jotform.com/answers/603470

    We will attend to it shortly.

    Thanks.