Add additional column in Spreadsheet

  • rmcorr
    Asked on July 5, 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 ?

  • BJoanna
    Replied on July 5, 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.

    Add additional column in Spreadsheet Image 1 Screenshot 20

    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.

  • rmcorr
    Replied on July 5, 2015 at 1: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!

  • jonathan
    Replied on July 5, 2015 at 1: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.