Is there a way to only send submissions that are approved to an excel report?

  • duqadmin
    Asked on January 6, 2017 at 3:29 PM

    Good afternoon,

    We are looking to send only the approved submissions (page 2) to the report. Is this possible?

    If I need to rearrange the form, that is okay.

    Currently, we have the form being submitted by the user, another person receiving the notification and jumping to the hidden page 2 via a link in the notification to approve or deny the information.

    Thanks in advance!

    Best,

    Robin

  • Kiran Support Team Lead
    Replied on January 6, 2017 at 6:15 PM

    Unfortunately, it is not possible to filter Excel reports based on a field value. However, you may download the complete report to Excel and then filter the values in Excel itself.

    Following links may be helpful in filtering Excel data.

    http://www.excel-easy.com/data-analysis/filter.html

    You may also create a Pivot table in Excel for advanced reports. Please take a look at the guide below:

    https://support.office.com/en-us/article/Create-a-PivotTable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576

    Hope this information helps! Let us know if you are referring something different. We will be happy to help.