Custom field not showing in list of custom fields to display in custom report
Created a custom report in table layout based on tasks and subtasks and filtered to a specific custom item type. The report shows all of the correct records but I'm trying to add a few custom fields that exist on those custom item type records. Two of the custom fields I use on these records appear in the Custom Fields section when I click the gear to choose which fields to show as columns in the report. But the other fields don't appear.
If it matters:
- Of the two fields that I CAN pick, one is text-based and one is single-select list-based
- Of the fields that don't appear as choices, all are text-based
- As far as I can tell, all properties of all of these custom fields (other than field type) are identical. Applied to = all, Author = me, Belongs to = same space, Can see = everyone, Can edit = everyone
This is the column chooser panel where I'm expecting to see but not seeing these fields appear. Interestingly, there are other custom fields I can choose that aren't even used in the custom item type I'm trying to report on.
I should have also mentioned that the custom fields I'm trying to pull into this report are populated for at least some of the records that appear in the report.
Semi-answered my own question but this seems like a bug. I found that if I navigate to the parent folder of the projects where these task records live, create a new table-based view of that folder, and force-search for the missing custom fields, I'm able to add them to that table-based view of the parent project. After doing that, magically I can now choose these same fields in the custom report.
Hey Chris (AIS-BI) Martin, let me ask our Support team to look into this. I'm creating a ticket for you.
Thanks a lot for bringing this up!
Lisa Community Team at Wrike Wrike Product Manager Conviértete en un experto en Wrike con Wrike Discover
Lisa Wrike Team member Conviértete en un experto en Wrike con Wrike Discover
I can confirm the same issue in our Wrike account. Thank you, Chris Martin, for the workaround - it worked for us as well.
Rohan V Community Team at Wrike Wrike Product Manager Conviértete en un experto de Wrike con Wrike Discover
Rohan V Wrike Team member Conviértete en un experto de Wrike con Wrike Discover