Adding columns inside the exported Report

  • RHemery
    Asked on May 22, 2015 at 3:56 AM

    Hi there

    Is there any way to change the exported spreadsheet from 'Reports' on a form? Or is it generic and unchangeable?

    We are hoping to make it so when the report is exported, additional blank columns (that we are using to display a countif table value) are produced automatically, so we can just paste in the countif table.

    Please see screenshot for what I am suggesting. G, H, J and K are blank.

    Regards

    Richard

    Jotform Thread 574363 Screenshot
  • Boris
    Replied on May 22, 2015 at 5:37 AM

    Hello Richard.

    If I understand your requirement correctly, you can do this by adding a couple of empty fields to your form, between the fields where you want them to be. Then, please set these fields as Hidden.

    Adding columns inside the exported Report Image 1 Screenshot 30

    When you are generating your report, simply make sure that all of these hidden fields are included in your report:

    Adding columns inside the exported Report Image 2 Screenshot 41

    Your excel report should now have these empty columns automatically inserted.

    Please let us know how it goes, or if you need further assistance with this.

    Kind regards.

  • RHemery
    Replied on May 22, 2015 at 5:42 AM

    Awesome, thank you so much.

  • Boris
    Replied on May 22, 2015 at 7:21 AM

    You are kindly welcome.

    Please don't hesitate to contact us again if you have other questions, we will be happy to help.