Adding columns inside the exported Report

  • Profile Image
    Asked on May 22, 2015 at 03: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.



  • Profile Image
    Answered on May 22, 2015 at 05: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.

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

    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.

  • Profile Image
    Answered on May 22, 2015 at 05:42 AM

    Awesome, thank you so much.

  • Profile Image
    Answered on May 22, 2015 at 07: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.