Reprt Builder: How to download a report based on filter?

  • Monique_Samsen
    Gevraagd op 16 oktober 2023 om 09:12

    Goedemiddag,

    Wij gebruiken Jotform voor evaluatieformulieren voor onze trainingen. Nu wil graag per trainer een rapport opmaken. Maar als ik het filter toepas, dan wordt het rapport opgemaakt obv het filter, maar als het ga downloaden, krijg ik het obv alle formulieren.

    Hoe kan ik dat voor elkaar krijgen?

    Ik hoor het graag via info@act4kids.nl.

    groeten Corry van Ginhoven,
    namens Monique Samsen / ACT4kids

  • Joram_Perucho
    Geantwoord op 16 oktober 2023 om 09:27

    Hi Monique,

    Thanks for reaching out to Jotform Support. Unfortunately, our Dutch Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Dutch, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

    Now, let me help you with your question. Are you referring to the Download All button in the Submission Table? Did you mean that when you filter the submissions by the name of the trainer, you still get all the submissions for that form? If this is correct, unfortunately, you can only download filtered submissions if they are filtered using date range. You can also filter them by email, and then check the button for each before clicking the download button.

    Give it a try and let us know how it goes.

  • Monique_Samsen
    Geantwoord op 16 oktober 2023 om 09:54

    Hi Joram,

    Thanks for reaching out.

    What I do now is the following: - I filter on all forms with "joyce":
    Reprt Builder: How to download a report based on filter? Image 1 Screenshot 40

    Then I see the correct report (with everything from Joyce):

    Reprt Builder: How to download a report based on filter? Image 2 Screenshot 51

    But when I try to download the rapport of Joyce, I get the download of all completed forms (from all trainers).

    So I'm reffering to this download button:
    Reprt Builder: How to download a report based on filter? Image 3 Screenshot 62

    Can you help me?

    Thanks a lot!

    Corry

  • Neil Enterprise Support
    Geantwoord op 16 oktober 2023 om 12:24

    Hi Corry,

    Thanks for reaching out to Jotform Support. It's great to know that you utilized the filter function. Now, to be able to download specific data reports, you will have to add the name of the trainer in the Advanced Filters. Check out my screenshot below for an example:

    Reprt Builder: How to download a report based on filter? Image 1 Screenshot 30

    After you apply the filter, you can now download the report, and it only downloads the filtered data.

    Reprt Builder: How to download a report based on filter? Image 2 Screenshot 41

    Give it a try, and let us know if you need more help.

  • Monique_Samsen
    Geantwoord op 17 oktober 2023 om 05:49

    Hi Joram,

    Thank you! This indeed helps a lot, but.... Only when the report is downloaded will not all comments be visible. How do I achieve that?

    (you can't see what's under the slider - see image)

    This is online:
    Reprt Builder: How to download a report based on filter? Image 1 Screenshot 30

    This is in de PDF:
    Reprt Builder: How to download a report based on filter? Image 2 Screenshot 41

    I hope you have a solution for this to! (sharing the link is not our preference, because we do not want to burden the trainers to log in)

    Hope to hear from you!
    Corry

  • Leonidas_D Jotform Support
    Geantwoord op 17 oktober 2023 om 07:58

    Hello Corry,

    Thanks for getting back to us. I’ll need a bit of time to work out a solution. I’ll get back to you shortly.

    We understand your patience and understanding.

  • Leonidas_D Jotform Support
    Geantwoord op 17 oktober 2023 om 08:15

    Hello Corry,

    Thanks for patiently waiting. I understand that you would like to download the complete table of the submission report using the Report Builder. As a workaround, you can try to increase the size of the table layout. Here's the screencast on how to do that:

    Reprt Builder: How to download a report based on filter? Image 1 Screenshot 20

    Give it a try and let us know how it goes.