Skip to main content
Level 9
November 14, 2018
Question

Report showing projects with custom forms attached

  • November 14, 2018
  • 12 replies
  • 1893 views
Hello~ Anyone know how I can create a report that shows what custom forms are attached to what projects? Thank you, Susan Susan
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

12 replies

Level 10
November 20, 2018
In your filter, it looks like you still have the example custom form ID that I provided. Since this is not an ID you'll have access to, it won't work. You'll need to replace this with the ID of your own custom form. @William English gave some good instructions on how to find the ID of your form here: "https://community.workfront.com/discussions/community-home/digestviewer/viewthread?MessageKey=0b39753b-7a96-40bd-871a-7f4a789b246f&CommunityKey=ccf3381b-a473-4ef2-9f81-4dd3244cf522&tab=digestviewer#bm0b39753b-7a96-40bd-871a-7f4a789b246f">Re: Report showing projects with custom forms attached Narayan Raum Workfront CoE Manager & Delivery Lead SunTrust Bank
SusanPfAuthor
Level 9
November 20, 2018
Hello, Narayan. Once again I've hit a problem. Please view the code and make sure okay. Thank you! Susan Susan
SusanPfAuthor
Level 9
November 20, 2018
Willam, thank you! Susan
SusanPfAuthor
Level 9
November 20, 2018
Thank you! Susan
AlisonW
Level 5
November 16, 2018
This is less elegant than the solutions already proposed, but I have added a radio button field to certain custom forms. It defaults to checked, and then I can simply run a report looking for that field which will automatically be checked if the form is attached. Alison Wells Community Medical Centers
William--
New Participant
November 15, 2018
Hi Susan, when building a view or a report, type "Category Name" in the field finder in the top left corner: If you want to display only the records that have a certain form attached to them, you will still need to copy/paste Narayan's code into the filter using text mode. (If you have other filters you want to use in addition, add those first as normal, then switch to text mode and paste at the end) To get the ID number of the form you are filtering for, you need to add a column to your view in Setup >> Custom forms that shows the ID: The above view isn't built in to Workfront when viewing custom forms, so you need to create a new view and add a column like below: (the above example also has some filters and groupings applied to my view of custom forms, so yours will look a little different) With the new view, now you can identify the ID number of any form that you want to filter for. Happy to setup some time to share screens via Lync if you need more help. William English Disney Destinations
If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
Level 10
November 15, 2018
Here's how you add the view and/or the filter, depending on your approach: https://www.screencast.com/t/oA1rvA0Wl
SusanPfAuthor
Level 9
November 15, 2018
Hello, Narayan. It didn't work. Where do I specifically place the code? I'm still learning text mode. Thank you, Susan Susan
SusanPfAuthor
Level 9
November 15, 2018
Thank you, William. What is the step-by-step process for getting the report you are referring to? Susan
SusanPfAuthor
Level 9
November 15, 2018
Thank you, Narayan! I'll give it a try and get back to you. Susan