textmode for filtering custom form in template report? | Community
Skip to main content
SkyeHa
Level 10
Sep 20, 2019 6:18 AM UTC
Question

textmode for filtering custom form in template report?

Is there any text mode for filtering for a custom form in a template report if your users are using multiple custom forms?

In a project report, it would be this:

objectCategoriesMM:ID=xxxxxxxxxxxxxxxxxxxxxxxxxxxxx

objectCategoriesMM:ID_Mod=in

(i.e. filter on Categories ID)

In a template report there's nothing. I did try copying over the code in the valuefield on the view (I think it's customFormsName), as well as the textmode from the project report. But everything errors out. So can I really only filter off the primary custom form in a template report (i.e. filter on Category ID)?

    14 replies

    HrugDe
    Level 2
    May 26, 2020 12:07 AM UTC

    I'm having trouble applying this code to a Project report. I would like to filter out projects that DO NOT have a specific custom form. Any code that I found here or concocted has not worked. All of our projects have multiple custom forms attached to them and I am not sure if this is impacting this effort. This is what I've tried:

    objectCategories:categoryID=5ecc319201c4e9a0200c66fa5bd12aae

    objectCategories:categoryID_Mod=notin

    I have also played around with several versions of EXISTS/NOTEXISTS code snippets to no avail.

    Any help would be appreciated!

    Translate
    BarryBu2
    Level 8
    Oct 28, 2019 11:59 PM UTC
    I don't think either can be bent to work for finding Form A AND Form B. An alternative approach would be if both forms have a mandatory field, have the filter to say Field on Form a is not blank AND Field on Form B is not blank. If either (or both) don't have a mandatory field, add a calculated field to each that just calcs to 1 and use a similar approach - Form A calc >0 AND Form B calc >0 Barry Buchanan - WMA Work Management Australia
    Translate
    AdinaPi1
    Level 9
    Oct 24, 2019 6:44 PM UTC
    Doug and Barry, I tried both of your filters in a task report to find tasks that had 2 specific task forms attached with no luck. It only shows if at least one of the categories are attached. Any ideas? Adina Pierce
    Translate
    JoeSalas
    JoeSalas
    Level 3
    Oct 8, 2019 3:37 AM UTC
    This code works for to find custom form(s) featured in templates. Thank you all for posting questions, feedback and many thanks to Doug for code! Kind regards, - Joe P.S. does this giphy format work in this forum Joe Salas Logitech International SA
    Translate
    SkyeHaAuthor
    Level 10
    Sep 25, 2019 8:03 PM UTC
    William: This flipped case doesn't work for me either way (in a report or on a template tab filter), and the way it fails indicates a need for an Exists statement. In other words, the result I get when I use a "notin" Mod is basically ALL the templates that have ANY custom form (so anything that isn't blank). -skye
    Translate
    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStore
    New Participant
    Sep 25, 2019 6:52 PM UTC

    Gotcha Bill,

    I applaud your keep yer views (and groupings and filters) as separate objects convention, and aspire to it myself, as well.

    It's unfortunate (and unusual) that it does not work as you'd expect, in this case.

    Regards,

    Doug

    Translate
    William--
    William--
    New Participant
    Sep 25, 2019 6:02 PM UTC

    That does work, Doug - kind of... It works in a report, but not where I was trying to do it - in the template landing page list.

    I guess the real problem is the manner in which I create filters and views. It may be a bad habit of mine, but when I'm creating a report, I start by creating the filter and view in a landing page list. Then I create a new report and apply the existing filter and view. I fell into this habit because there were user requests to look at a single report, but have the ability to switch back and forth between the report's default view/filter and a the view/filter that exists on other reports. And, I found it an easy way to quickly update multiple reports with a new iteration of a view, or, apply a report filter in other reports/landing page lists.

    I'm still a fan of this practice, until things like this pop up where a filter works in a report but not a list view, or vice-versa. It's the second time in as many weeks!

    Translate
    If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
    SkyeHaAuthor
    Level 10
    Sep 25, 2019 8:59 AM UTC
    thank you Doug! That worked. My user assured me he'd always have a use for that formula, so I appreciate all the time you took in noodling that out :) -skye
    Translate
    Doug_Den_Hoed__AtAppStore
    Doug_Den_Hoed__AtAppStore
    New Participant
    Sep 25, 2019 6:11 AM UTC

    Hi Bill,

    I invite you to stop beating your head against the wall, as this second line finds Templates that do NOT have a particular custom form:

    objectCategories:categoryID=41b3dac47210ff4da13ea1c3748ab204

    objectCategories:categoryID_Mod=notin

    Sleep well.

    Regards,

    Doug

    Translate
    William--
    William--
    New Participant
    Sep 25, 2019 5:48 AM UTC

    I'm so mad! I tried approximations of both Barry's and Doug's solutions over the weekend, but couldn't get my use case to work.

    In my case, I was trying to do a similar thing as Skye, but list templates in which a specific form was *not* attached. Therefore, everything I tried had either a NOTEXISTS or _Mod=notin modifier.

    So, any idea how to do this with a not equal modifier?

    Translate
    If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
    Show more replies
    Terms & ConditionsAccessibility statement

    Loading footer...