AnsweredAssumed Answered

filered value list/ filtered table occurance

Question asked by margotjacqz on Oct 19, 2012
Latest reply on Oct 22, 2012 by margotjacqz


filered value list/ filtered table occurance


     I am trying to limit a drop down list in the following set up.

     TO=Action related to a join table of IDs which link to several other TOs of Jobs, Names, Companies.

     New Action Layout has portals to the others. I know how to set up the lists, and show the resutling choices.

     What I want to do is limit the list, for example to Jobs that are open or companies in the us. I found the concept of creating a calculation field such as [if job status= open or job status=hold;1;0]. I am failing at the next step which is how to create the value list limited to x=1.

     Apologies if this has been covered many times, i found a couple of possible answers but lost track of the concept in the particular details and couldn't replicate. thanks all as always.