Grouping an Issue Report by IF a specific Custom Form is attached

[Alex_Di]

Hi Y'all, 

I'm trying to group an issue report based on if one of the custom forms is a specific form.  I have the below so far, but it's only working IF the form I'm looking for is the first form attached. 

group.0.linkedname=category
group.0.namekey=view.relatedcolumn
group.0.namekeyargkey.0=category
group.0.namekeyargkey.1=ID
group.0.valueexpression=IF(CONTAINS('63b8a952004ed663d6f5c5ed54e3a2ca',{category}.{ID}),"Digital","Other")
group.0.valueformat=string
textmode=true

Has anyone been able to make this happen? 

[skyehansen · Accepted solution]

hi there, a grouping for "category id" is designed to only look at the first form. There's no way from a "grouping" standpoint, to look at an entire collection of forms -- this is just how it works.

If it's important for you to see issues based on whether they have a digital custom form vs not, this would need to end up as two reports: one for all issues with a digital custom form, and one report for all issues without a digital custom form.

[Alex_Di]

Thank you @skyehansen , I was pretty sure that was the answer, but I was hoping for a workaround.

[Doug_Den_Hoed__AtAppStore]

Hi @Alex_Di,

I concur with @skyehansen...but can also suggest a cheat.

Loosely based on my Tunnel Of Death: How To Find A Form With Two Specific Custom Forms On It post, I invite you to:

• create a custom parameter (e.g. a calculated text parameter called "XXX Is Digital", where XXX is the custom form of interest)
• place that custom form ONLY on THAT custom form of interest
• Set the formula to the value of interest (e.g. ="Digital"), check the Recalculate box so it will populate on existing data, then Save and Close the custom form of interest
• Group your report by that custom parameter

As a result, data will group into "Digital" for those Issues with that custom PARAMETER (regardless of whether the custom FORM is first or not), and None for all other Issues...effectively then meeting your requirements.

Regards,

Doug

[Alex_Di]

Thank you @Doug_Den_Hoed__AtAppStore .  I can't believe I forgot about that post from you.  It seems like we have been cheating the system for a long time.  Thanks for the reminder. 

[Doug_Den_Hoed__AtAppStore]

My pleasure @Alex_Di,

If the end justifies the means and you use it to solve your requirement, I would be pleased to know.

Regards,

Doug

[RandyRoberts]

I agree with both Doug and Skye.

One "workaround" I have used is not to sort by if a form exists but by if it's been filled out. To achieve this, put a required field on a form and then group by that field. 

If it hasn't been filled out, it might as well not exist.