I have a choice filter applied to a select-one field. Essentially, the first choice is "company", if they select the ecology firm, the user can then select the ecology based "roles".
However, on occasion (often enough to be required) their may be a different contractor, and therefore a different company. And rather than having type out and therefore inevitably typo to job roles, I want the users to be able to access the full "roles" picklist.
My intial thought was something along the lines of;
if(${Company} = 'Other','',co=${Company})
in the choice_filter column. However, this doesn't work.