How to show live report of submissions on my Website/page?

  • Profile Image
    Ron
    Asked on September 16, 2013 at 07:07 PM

    URL or JS code to embed in my website that shows the reports of submissions  not as static but with ability to filter data dynamically as:

    1. nice dashboard graphs 

    2. tables

  • Profile Image
    khrisell
    Answered on September 16, 2013 at 10:49 PM

    Hello,

    You might want to consider our visual report feature.

    You can show the HTML table listing report on your website.

    The report may be accessed via direct link on our website, and placed (embedded) on your web pages. Report embedding option may be useful if you want to share the submitted data between form users.

    It comes with an optional Password protection, and sort submissions data by Ascending/Descending order (try to click on the column titles on your live report) features.

    Let's start with creating your first HTML Table Listing Report.
    (All data shown are just example for you to visually understand.)

    1. Click on the 'My Forms'  link.

    Click on My Forms



    2. Click on your form to 'Select' it.
    Select the form


    3. Click on the 'Reports' drop down, and then select the 'Add New Report' option.

    Click on the Reports



    4. Select the 'HTML Table Listing', and click on the 'Next' button.

    Add New Report



    5. Set the report 'Name', configure your report 'Fields', and enable the 'Password protection' option if you need it, then click on the 'Next' button.

    Report Options



    6. That is it. The report is ready. You will get a 'Direct link' to the Report, and the 'iFrame code' (that code is used for embedding, so you can embed the report on your web pages).

    Access and Share the Report



    This is how the report will look like:

    Report example


    Online example:

     

     

    Kindly let us know if none of this is what you wanted so that we could assist you further.

    Thank you for using JotForm.

  • Profile Image
    rleitman
    Answered on September 17, 2013 at 02:13 AM

    Thats good but not the ype of report I meant, as this report is static and I need to create it ahead and put in my site.  I need a dynanim way of doing it, for that I need to be able to embed something like you have in the submission page the bottom part of the screen ?

     

  • Profile Image
    ashwin_d
    Answered on September 17, 2013 at 03:16 AM

    Hello rleitman,

    If you add a "HTML Table Listing" report it will always display the updated records. That means it will work as dynamic report as it will display up to date list of submission records.

    I believe you should go ahead with suggestions of khrisell.

    Thank you!

  • Profile Image
    rleitman
    Answered on September 17, 2013 at 07:03 AM

    What I mean that I am missing a way to filter this report by dates or other values of fields, how can I do it ?  see all data doesnt help ...

  • Profile Image
    guilledutra
    Answered on September 17, 2013 at 10:10 AM

    Hi,

    You can use the "Grid report" instead of the "Table report", it will give the ability to the user to filter by selecting fields to show, also it have with a "search in submissions" input where the user can search by submission content.

    Hope it helps

    Thanks

  • Profile Image
    rleitman
    Answered on September 17, 2013 at 04:47 PM

    Thanks, Can I pass parameters to the URL of the gird/table to filer based on dates ? (or other fields).  Its very common in any report to filter by dates and it seems just to be missing here. If I have million submissions how can I show only the ones from today? or last week? for example.

  • Profile Image
    guilledutra
    Answered on September 17, 2013 at 06:04 PM

    Hi,

    I'm afraid that it is not possible to pass parameters to the grid report, the only way to filter submissions by date ranges is through the submissions page, but I think this is not what you are looking for. 

    I can forward your request to our feature request list if you want but I cannot commit if this feature will be implemented or not but you can be sure that our development team will see your request.

    Please let us know if you want this feature added to our request list,

    thanks

  • Profile Image
    rleitman
    Answered on September 18, 2013 at 07:17 AM

    Thanks, can I embed the submission page in my site?

  • Profile Image
    guilledutra
    Answered on September 18, 2013 at 09:34 AM

    It is not possible to embed the form submissions page in a website, however you can make it public previously protected by a password.

    Thanks

  • Profile Image
    rleitman
    Answered on September 22, 2013 at 10:23 AM

    Thanks, by making it public, then I can embed it in my site or only use the full page url with all the noise on header and footer ?  

  • Profile Image
    Welvin
    Answered on September 22, 2013 at 01:18 PM

    Hi,

    There's no option to embed the whole submissions page of your form but you can use iFrame Generators such as: Online iFrame Generator - iFrames Generator

    Yes, doing so would let everyone who have access to the submissions page see the header and footer sections.

    Thanks

  • Profile Image
    t3rra
    Answered on October 29, 2015 at 07:58 PM

    Would it be possible to show the result of one submission in a web page, then at the bottom of the webpage there be a signature widget and a submit button, where the viewer signs and hits submit, and all of the info gets sent to a certain email address?

    That's probably too much to ask but thought I'd try. Im working for a caterer who fills out their clients catering requests in an online form, it gets submitted to the caterer, who then sends it to the catering client for signature. 

    It would be great if the catering requests appeared in a webpage once submiited, and the caterers client just signs off on it.

     

     

     

  • Profile Image
    ashwin_d
    Answered on October 30, 2015 at 01:23 AM

    Hello t3rra,

    You seems to be looking for edit submission feature where user/client can sign and submit the form. You may like to check the following guide which should help you: http://www.jotform.com/help/40-How-to-Let-Users-Update-Their-Form-Submissions-at-a-Later-Date 

    Please be noted that since the edit link is generated dynamically as it includes submission ID, you will not be able to embed it in your webpage for every users.

    Thank you!

  • Profile Image
    christoffel
    Answered on January 09, 2017 at 03:34 AM

    My dashboard looks different, I can't see where I have to go to generate a report that I can put online or embed in my site.  Is there an update on this somewhere?  Rgds - Chris
  • Profile Image
    Helen
    Answered on January 09, 2017 at 05:04 AM

    Hi Chris,

    I have moved your question to another thread. You can follow your answer via this link:

    https://www.jotform.com/answers/1029016

    Please let us know if you need any further assistance.