Skip to main content
Nintex Community Menu Bar
Question

Daisy chain condition setting from Row Action

  • July 9, 2024
  • 6 replies
  • 27 views
J
Forum|alt.badge.img+7

I know I"m missing something here because this should be doable and magical.

I’m trying to allow users to click on a row action for “Initiatives” and update another “ActionsChosen” model.  They’re linked together with a custom junction object “InitiativeActions”

9efe1eaeed2941beaae54edd84d55e933198b1f7.png

Here are my steps:

  1. Activate and set model condition (initActionChosen> Initiative__r.Id = {{Id}}
  2. Query model (initActionChosen - completely rewrite data
  3. Activate model condition on ActionsChosen:
  4. Id in the set of values containing Action__c from initActionChosen model
  5. Query ActionsChosen model - completely rewrite data
I tried to build a wizard to display the information step by step and it looks like I don’t make it very far.  I can get the Id to show up in a template but when I try to set the value on Step 1 above with that Id, I get a blank table returned.

What am I missing?  Whoever can help me get this working will be a rockstar.

Thanks

Initiatives with linked actions:


Linking Initiatives with Actions


Schema:
7259c4b7fcff036d71eef629337542a8e9744ba2.png

    6 replies

    J
    Forum|alt.badge.img+20

    The issue is in that you can’t set a value in an object that you haven’t yet queried. ie.  Initiative__r.Id = {{Id}}

    This should be Initiative__c = {{Id}}

    J
    Forum|alt.badge.img+7
    • Joe_Ort
    • Author
    • 95 replies
    • July 9, 2024

    Tried that before (and again)… no dice.

    J
    Forum|alt.badge.img+20

    Long explanatory posts drive me nuts. Can you record a video? There’s a free Chrome extension for this that uploads to youtube.com called Techsmith Snagit. 

    https://chrome.google.com/webstore/detail/techsmith-snagit/fcnghgbgmemnlbckdipnmelbanpgneik?utm_source=chrome-app-launcher-info-dialog

    J
    Forum|alt.badge.img+20

    Better yet would be to do a screenshare.

    J
    Forum|alt.badge.img+7
    • Joe_Ort
    • Author
    • 95 replies
    • July 9, 2024

    Answer:
    Subquery the junction object instead of trying to filter the junction and use that filtered model to use a field on it to filter another table.e4e36a85fe3c8a7279d0f78cc31d938bb2e60fb7.png

    Pat’s the man, the magician and a rockstar.

    Thanks

    J
    Forum|alt.badge.img+20

    One more thing. Set up another webex.


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement