How to have Live Excel Report?

  • Profile Image
    529concession
    Asked on December 12, 2017 at 01:48 PM

    Hello,


    I use the Jotform for online Print submissions and I was wondering if there is way to show live online table view that I can add the costs to each of the clients submissions.

    I see that I have the option to have HTML Table but I can't add cost field to that report and I know that I can download an Excel file but once downloaded it becomes outdated and not live so I need to download new Excel Report each day.


    Thanks.

    Mario

  • Profile Image
    Nik_C
    Answered on December 12, 2017 at 02:54 PM

    If HTML or Grid reports are not working for you:

    1513108092Screen Shot 2017-12-12 at 8.53

    And I'm not sure why, since you can choose all fields that will show and share the link:

    1513108142Screen Shot 2017-12-12 at 8.50

    Again, if that doesn't work for you, maybe you can integrate with Google Spreadsheet and share the read-only link to it: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    1513108438Screen Shot 2017-12-12 at 8.58

    Here is the link: https://docs.google.com/spreadsheets/d/e/2PACX-1vTPDBXdZCQ72lTmjzl0qHi8-SbXqf09TTTOZ0d1suwGuDnQzLoiz2l9-yeV0ASwsr7gtHRN-XHonrQP/pubhtml?gid=0&single=true

    The document will update automatically with each submission.

    Let us know if that could work for you.

    Thank you!