Add additional column in Spreadsheet

  • Profile Image
    rmcorr
    Asked 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 ?

  • Profile Image
    BJoanna
    Answered 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
    rmcorr
    Answered 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
    jonathan
    Answered 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.