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

textmode for filtering custom forms in project report

  • August 27, 2024
  • 1 reply
  • 775 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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
Community Advisor
August 27, 2024

 

Hi @abibeggs,

 

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

 

Regards,

Doug

    A
    AbiBeggsAuthor
    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

      Terms & ConditionsAccessibility statement

      Loading footer...