You are viewing limited content. For full access, please sign in.

Question

Question

Is it possible to design a Report in Forms 10.4 where i can extract only the Approved submissions?

asked on June 8, 2020

I have a report where  i list the required columns including the approved rejected status of the form submission. The Business User is requesting to narrow the report down to approved requests alone? Is that possible?

0 0

Answer

SELECTED ANSWER
replied on June 8, 2020

Yes, what version of Forms are you on? You should be able to add a filter to the report definition to only show the instances at the approval end event. 

1 0

Replies

replied on June 8, 2020

Is the status a field on the form? Or an action a user can take on a user task? 

I would suggest filtering by the end event. For your approval branch, you should have an end event named something like "Approval End", "Rejection End" for the rejection branch and whatever other end events. You can use a filter on the end event to just get the completed instances that were approved. 

1 0
replied on June 8, 2020

The status is the approval on the user task. Yes I have an approval end and rejected end on the status. I see the dropdown where  I can pick the field or action.

is there a filter option in the report?

0 0
SELECTED ANSWER
replied on June 8, 2020

Yes, what version of Forms are you on? You should be able to add a filter to the report definition to only show the instances at the approval end event. 

1 0
replied on June 8, 2020

Am on 10.4 forms. Let me check.

0 0
replied on June 8, 2020

Perfect! Was able to set the filter on the Approved end step. Thanks!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.