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

Question

Question

is there a way to create a form report and only count the most recent record based on a user ID?

asked on September 4, 2024

I have a form that asks employees to answer a question through a radio button, there are 3 options to select from, and I'd like to create a report of the answers provided.

For the report, Id like to only include the most recent entry, instead of counting all the times the same user provided a response, is there a way to do this?

0 0

Replies

replied on September 5, 2024
  • Ensure User ID and Timestamp are available as process variables or fields.
  • Use SQL queries or the built-in report designer to group by User ID and retrieve only the latest entry.
  • Display the filtered report.
0 0
replied on September 12, 2024

Another option if you don't need to keep each entry in a local table is to have workflow do a search if that user already has an entry in your table, delete it and then add in the new one.  This way you aren't storing data you don't really need, and you always have the latest entry.

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

Sign in to reply to this post.