List for dashboard with different options than field values

(Mach Zreik) #1

I’m trying to create a dashboard for POs. One of the things that I’d like to do is have a filter that users can choose for the Approval Status. The statuses in the field are U, A, R, & P. But What I want the list to show is Unapproved, Approved, Rejected, & Pending.

I created an UltraCombo but that’s as far as I got before realizing it’s not intuitive.

Thanks for the help.

(Pierre Hogue) #2

You could use a UserCode list, and use epiCombo object.
ex: ComboBox - UD Table or User Codes


(Calvin Krusen) #3

@Machzy - You could add a calculated field to the BAQ that shows the Status as the “long text” instead of just the code. Then have your filter tied to the calculated field instead of the actual status field.

(Robert Hartshorn) #4

He already has the field and values he needs, so UD is overkill. He should just handle the display value on the BAQ level per @ckrusen suggestion.

(Mach Zreik) #5

Thanks @ckrusen, that’s what I ended up doing