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

    Using a custom property to filter data

      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 ?