4 Replies Latest reply: May 16, 2016 6:40 AM by Jeffrey Goldberg RSS

    Using a custom property to filter data

    Emilio Leo

      Hi all,

       

           I'd like to define a custom property named "SalesOrder" and assign it to each user that is a Project Manager. The values allowed for this custom property are the SalesOrder number of projects that each PM is in charge of.

       

      In a table inside the app, I'd like to filter values with an IF statement that check the values of this custom properties ... something like this:

       

      If(SalesOrder=@SalesOrder, SalesOrder, null())

       

      Where SaleseOrder is a field name and "@SalesOrder" is the custom property mentioned above.

       

      ... but this doesn't work ... am I wrong in something or it is absolutely not possible ?

       

       

      Cordialement.