Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have a case where I want to add a button with "Select in Field".
I have the fields:
CustomerID
CustomerSale
CustomerBudget
And I want to create a button that filters on all CustomerID where CustomerSale is bigger than CustomerBudget
I thought I could use CustomerID as Field, and =(CustomerSale > CustomerBudget) as Search String, but no go.
Any suggestions?
There's a little specific for the search string syntax in an action, try
='=CustomerSale > CustomerBudget'
There's a little specific for the search string syntax in an action, try
='=CustomerSale > CustomerBudget'
Thanks for the try, but it doesn't seem to work (Expression OK, but nothing happens).
Can you post some details about your data model (how are the three fields related to each other)?
Do you have several CustomerSale records per ID?
Try also
='=sum(CustomerSale) > sum(CustomerBudget)'
(as is, including the single quotes an the preceding equal sign, as search expression)
I'm sorry, your suggestion worked, but I'd chosen "Select in Field" instead of "Toogle Select".
Thanks, it works perfect now!