Skip to main content

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

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}}

Tried that before (and again)… no dice.

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

Better yet would be to do a screenshare.

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

One more thing. Set up another webex.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings