Allow excel report to be accessed by other users

  • ontmoetingscentrumeenheid
    Asked on March 4, 2020 at 10:18 AM

    Hallo,

    Hoe kan ik een excel-rapport door derden zichtbaar maken?

    Ik kan een link aanmaken van de excel lijst en wens deze door te sturen naar een derde die dan eveneens de lijst kan raadplegen (= aantal inschrijvingen voor een bepaalde aktiviteit bv).

    De link is wel leesbaar op een PC waar JotForm is op  geïnstaleerd maar anderen niet.

    Dank bij voorbaat voor jullie reactie

    Cathérine

  • John Support Team Lead
    Replied on March 4, 2020 at 1:54 PM

    Hello Catherine - You can use the following workarounds:

    GRID REPORT - This will allow you to generate a URL that when accessed, a GRID REPORT will be shown with all the submission data in it. You can also password-protect it.

    Here's an example URL - https://www.jotform.com/grid/200505227442040

    GUIDEHow-to-Create-a-Grid-Listing-Report 

    EXCEL REPORT - This report feature lets you generate an Excel Report of the submissions and share it with others using a generated URL.

    Here's an example URL - https://www.jotform.com/excel/93326535083054 

    GUIDEHow-to-Create-an-Excel-Report 

    Please try these and let us know how it goes.

  • ontmoetingscentrumeenheid
    Replied on March 5, 2020 at 3:50 AM
    Hello,
    Thanks for your reation.
    I was already abble to create an Exell report and URL.
    My problem is that when I send the URL to another person he can’t open the exell (You’re not authorized) , while my college and I are able to open it.
    Cathérine
    [cid:image005.jpg@01D46ADD.AD194C60]
    Van: JotForm
    Verzonden: woensdag 4 maart 2020 19:55
    Aan: Info Centrum Eenheid
    Onderwerp: Re: Link voor excel rapport zichtbaar door derden
    A new response has been received:
    [JOTFORM]
    Answered by JohnRex
    Hello Catherine - You can use the following workarounds:
    GRID REPORT - This will allow you to generate a URL that when accessed, a GRID REPORT will be shown with all the submission data in it. You can also password-protect it.
    Here's an example URL - https://www.jotform.com/grid/200505227442040
    GUIDE: How-to-Create-a-Grid-Listing-Report
    EXCEL REPORT - This report feature lets you generate an Excel Report of the submissions and share it with others using a generated URL.
    Here's an example URL - https://www.jotform.com/excel/93326535083054
    GUIDE: How-to-Create-an-Excel-Report
    Please try these and let us know how it goes.
    View this thread on browser » Unsubscribe Thread
    1583348071
    ...
  • Bojan Support Team Lead
    Replied on March 5, 2020 at 8:44 AM

    Greetings and thank you for your reply.

    In order for other people to see and download data from your account, you need to change the settings for it in your account settings.

    You can click on your profile image in the upper right corner, and click the Settings link. Once there, please uncheck Require log-in to see submissions under the Privacy section to allow everyone to see the submitted data:

    Allow excel report to be accessed by other users Image 1 Screenshot 20

    Please let us know if this solved your problem.

  • ontmoetingscentrumeenheid
    Replied on March 5, 2020 at 9:39 AM
    Hello,
    I think this is not the solution, because the setting is already as you told me to do.
    Please see below:
    [cid:image001.png@01D5F2FD.9980CB20]
    Met vriendelijke groeten
    Cathérine
    [cid:image005.jpg@01D46ADD.AD194C60]
    Van: JotForm
    Verzonden: donderdag 5 maart 2020 14:45
    Aan: Info Centrum Eenheid
    Onderwerp: Re: Allow excel report to be accessed by other users
    A new response has been received:
    [JOTFORM]
    Answered by Bojan_J
    Greetings and thank you for your reply.
    In order for other people to see and download data from your account, you need to change the settings for it in your account settings.
    You can click on your profile image in the upper right corner, and click the Settings link. Once there, please uncheck Require log-in to see submissions under the Privacy section to allow everyone to see the submitted data:
    [https://cms.jotform.com/uploads/image_upload/image_upload/global/101994_Screenshot_1.png]
    Please let us know if this solved your problem.
    View this thread on browser » Unsubscribe Thread
    1583415876
    ...
  • Bojan Support Team Lead
    Replied on March 5, 2020 at 10:52 AM

    Thank you for your reply.

    Unfortunately, we are unable to see your screenshot. Please note that you are not able to add screenshots by replying to an email. You can see the full explanation if you click here.

    Furthermore, please make sure the Require log-in to see submissions is not checked. Require log-in to view uploaded files option is for data submitted in the form, and not the submission itself.

    Allow excel report to be accessed by other users Image 1 Screenshot 20Thank you for your cooperation.