Show a subset of respondants on a different website

  • Profile Image
    jolizzy
    Asked on September 19, 2017 at 01:50 PM

    Some of the people who registered for my event are approved, and some are waitlisted due to lack of space. Is there a way to show only the approved ones on my website?  Or do I have to show everyone, and reveal the administrative "status" field?

    I want the names to appear under the "Confirmed" section on the website.

  • Profile Image
    Nik_C
    Answered on September 19, 2017 at 03:01 PM

    I'm afraid that there is no other option aside what you already did, showing the report embedded in the website.

    Since there is no way to filter reports based on field selection. You can only select the fields that will show in the report, as you did.

    Maybe something can be done with Spreadsheet integration where you could create some logic that will show only cells when they are "approved". And then you could embed the spreadsheet as you did with a report. 

    Here is how to filter rows in Excel based on cell's value: https://www.extendoffice.com/documents/excel/2975-excel-hide-row-based-on-cell-value.html

    And then you could embed the spreadsheet in your web page:


    Let us know if this could work for you or if you need any assistance.

    Thank you!