Excel Report: Custom columns added in the Sheets page are not included in the exported file

  • adminufv01
    Asked on April 9, 2020 at 7:31 AM

    Hi!

    I've created a new column in a sheet (form id 200962036728052) and it shows what it should show.


    But if a create a new report (table or Excel), altouhg I can select that new column, it doesn't appear on the report.


    Thanks!

  • Bert_A
    Replied on April 9, 2020 at 9:59 AM

    Hi there, thank you for reaching out.

    I've done a test on a clone of your form, created a report and it seems as though all the fields are included on the excel sheet as you can see in the screen capture below.


    Excel Report: Custom columns added in the Sheets page are not included in the exported file Image 1 Screenshot 20

    May I please confirm if there's a part that I'm missing with your concern?

  • adminufv01
    Replied on April 9, 2020 at 11:30 AM

    Hi! Thanks for anwering and sorry, because a I deleted the column.


    I've created a new column (called "New column") and I cannot see it in my Excel report (nor the column nor the data).


    http://somup.com/cYfQoU1KAF


    Thanks!!

  • Welvin Support Team Lead
    Replied on April 9, 2020 at 1:43 PM

    I was able to replicate the problem with the Excel Report option. I think that is because it is not considered a field. 

    Excel Report: Custom columns added in the Sheets page are not included in the exported file Image 1 Screenshot 20

    I have raised this thread to our backend team to clarify this matter and to see if they can include custom columns in the report. Once we have an update, you will be notified here.

    Thank you for reporting. 

  • Welvin Support Team Lead
    Replied on April 9, 2020 at 3:04 PM

    The custom column worked when downloading through the Sheets page, so as a workaround, do it there instead of the Excel Report.

    https://www.jotform.com/help/269-How-to-View-Form-Submissions

    Excel Report: Custom columns added in the Sheets page are not included in the exported file Image 1 Screenshot 20

  • stravieso
    Replied on April 9, 2020 at 3:22 PM

    Thanks.


    This works, but I cannot:

    1. Create a table report where others can access some information

    2. Get a direct link: I use the Get Data button in Excel to automatically access the data. With this, I have to download the Excel file each time there is an update.


    I hope you can fix this bug.


    Thanks again

  • adminufv01
    Replied on April 9, 2020 at 3:25 PM

    Hi! The account stravieso is my personal account.

  • Welvin Support Team Lead
    Replied on April 9, 2020 at 4:45 PM

    Is that a table report through another report creator that based its result to the excel report URL or do you mean our HTML Table report? 

    The ticket was already submitted. Unfortunately, we cannot provide you an ETA of the ticket, but as soon as we get an update, we will surely notify you here.

  • omergulen
    Replied on October 5, 2020 at 3:02 AM

    This issue is fixed now.

    If you need any further assistance please do not hesitate to ask.

  • adminufv01
    Replied on October 5, 2020 at 6:55 AM

    Such great news! It works perfect now!!

    Thanks!