condition quandary

Matt SonesMatt Sones Member ✭✭
edited June 25 in Questions
Will someone help me figure out how to write conditions for this case?

I have a model (ModelA) with a lookup field called Staff__c.
I have a model (SelectedStaff) which will either be empty (if no staff is selected) or have one row.

I want ModelA to return records where Staff__c=null when the SelectedStaff model is empty, and Staff__c=(SelectedStaff)(Id) when it's not empty.

I'm struggling to write conditions to do that. Help?

Comments

  • Pat VachonPat Vachon Member 💎💎💎
    edited June 25
    GTM?
  • Matt SonesMatt Sones Member ✭✭
    edited November 2017
    If that means "got a minute?" then yes.
    Otherwise, I have no idea.
  • Matt SonesMatt Sones Member ✭✭
    edited June 25
    Ah.

    I'm just going to use Staff__c = "" filterable default on for ModelA, and run a model actions on query of the SelectedStaff model to set the value and query ModelA. The only downside here is that I can't have skuid 'remember' the selected staff... it has to start off empty.

  • Pat VachonPat Vachon Member 💎💎💎
    edited November 2017
    lol.... gotomeeting
  • Pat VachonPat Vachon Member 💎💎💎
    edited November 2017
    All set then?
  • Matt SonesMatt Sones Member ✭✭
    edited November 2017
    yep! thanks.
  • Matt SonesMatt Sones Member ✭✭
    edited November 2017
    hahaha, ok.
Sign In or Register to comment.