textmode for filtering custom forms in project report | Community
Skip to main content
New Participant
August 27, 2024
Solved

textmode for filtering custom forms in project report

  • August 27, 2024
  • 1 reply
  • 759 views

I would like to filter out projects that DO NOT have a specific custom form attached + that DO have other specific forms attached. We're able to easily collect one at a time but we cannot combine the two filters, does anyone have any suggestions on how we could achieve that? 

 

Almost all of our projects have around 5 custom forms attached, not in any particular order unfortunately.

 

For example, we would like to have a report showing what projects have our 'internal reporting form' but are missing the 'audit form'.

 

Any suggestions are appreciated!

Best answer by Doug_Den_Hoed__AtAppStore

 

Hi @abibeggs,

 

I invite you to consider this Tunnel Of Death post, and/or using a NOTEXISTS filter.

 

Regards,

Doug

1 reply

Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAccepted solution
New Participant
August 27, 2024

 

Hi @abibeggs,

 

I invite you to consider this Tunnel Of Death post, and/or using a NOTEXISTS filter.

 

Regards,

Doug

AbiBeggsAuthor
New Participant
August 27, 2024

thanks! for anyone else looking for this, this filter ended up working for me:

 

EXISTS:A:$$EXISTSMOD=NOTEXISTS
EXISTS:A:$$OBJCODE=OBJCAT
EXISTS:A:categoryID=ID of our Audit form
EXISTS:A:objID=FIELD:ID
objectCategories:categoryID=IDs of the internal reporting form

objectCategories:categoryID_Mod=in