Hi
I am trying to get a field to become visable on the Quote Module only if the Customer Number selected is equal to a specific number such as 323001419.
The visability of the field is dependent on a formula. This is the formula i have tried is below
related($billing_accounts,"pr_account_number_c")isInList(323001419,createList(323001419,323001420)=true.
Its not working for me. Anyone have any ideas?
Hi Rosemarie,
When creating a dependent formula, the primary formula needs to be a boolean-type (i.e. returns true or false). You have the right elements in your example, but they need to be reorganized. The formula you should use is:
isInList(related($billing_accounts,"pr_account_number_c"),createList(323001419,323001420))
This means that the formula will compare the pr_account_number_c field against the defined list in your formula. If the value exists, true will be returned and the field will be displayed.
I hope this helps!
