3 Replies Latest reply: Aug 3, 2015 2:02 AM by Srinivasan R RSS

    Set field to multiple values, based on an expression, through an action button?

    Clarissa Buda

      Can I set a field value equal to a list in an action? 

      For example, if I have 5 properties, and I've assigned these properties flags. I want to create a button so that when the user clicks the button, the action will assign the field with the properties which have a flag of '1'. 

      So if my data looked like this:

      Prop     Flag

      Prop1     1

      Prop2     1

      Prop3     0

      Prop4     0

      Prop5     1

      When the user clicks the button, I'd like the field 'Prop' to equal Prop1 and Prop2 and Prop5.

       

      As an added twist...I'm not assigning these flags in the script.  They would be driven by an if statement which assigns the flag based on whether or not the property has data for all of the given years that user is trying to see.  (I'm doing this so that if the user wants to see a spread of 3 years, and one of the properties only has data for one of those 3 years, it would exclude the property...a way to normalize the numbers...)  I've got my formula working fine for that, so I'm able to identify which properties I'd want the user to see when they click the button, but I'm stuck on how to set the field equal to multiple values based on the result of another formula.

       

      I tried to keep this basic, without my own field names and such, just to avoid confusion, but if you need more detail to solve, let me know.

      Or if you have another idea of how to accomplish this, that would be great as well!