Expand my Community achievements bar.

Is there a way to report on when a custom form was last used abd the fields that are associated with those forms?

Avatar

Level 2

I am in the process of working with some coworkers to determine what custom forms we can deactivate (or potentially delete) because they are no longer in use and the data tied to them is not relevant. I managed to make a custom view in the backend under Custom Forms > Forms and I have managed to create a custom view under Custom Forms > Fields that shows me what fields are associated with what forms. What I was hoping to be able to do is combine the two into one report, preferably in the custom form view that I created. However, I think that Workfront treats Forms, Fields, and Sections as their own thing and don't allow for hybrid reporting because of this separation of data. I thought that I might be able to utilize the text editing for the column parameters in an effort to pull in field data. But, one, I don't know if that would even work. And two, I have no idea how I would code it out (I am the furthest thing from a coder).

 

Any help would be greatly appreciated.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Community Advisor

I did this once a long time ago and I took the easy route since it was a one-time thing. One example is in determining if a task-based form/field was recently used, I created a task report with a column for that field or fields, then sorted by last updated date (or creation date) and then looked for the last cell that wasn't blank. That told me the last time it was used or filled out.

By focusing on the object the field was used on and not the form or field itself, it allowed for more robust and flexible reporting, leading to a faster solution.

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use.
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/mysocalledideas