Getting the "Display Value" of a dialog list field that uses an alias

I have a profile field that has a list of values with an alias.

For example the field has the following values:

Value 1|1

Value 2|2

Value 3|3

I have another form that has a dialog list field that uses a formula to get the list of possible values from the field on the profile document.

When a value is selected it correctly stores the alias value.

The form correctly displays the “Display Value” in the field. Example if the value of the field is “2” the value displayed on the form is Value 2.

Now I want to display the “Display Value” in a view. I realize I can have a big forumula. @If(MyField=“1”;“Value 1”;MyField=“2”;“Value 2”;“Value 3”);

But the list can change and can fairly long. I would then have to update the design of the view.

How can I show the “Display Value” of MyField in the view? I’d like to do it in the view itself but have a second “Display value” field would probably be OK to.

Subject: Getting the “Display Value” of a dialog list field that uses an alias

You might try to solve it by using a shared field.

Subject: RE: Getting the “Display Value” of a dialog list field that uses an alias

So how exactly is a shared field going to solve the problem?

Subject: RE: Getting the “Display Value” of a dialog list field that uses an alias

No way to easily deal with this at the view level. You could use FieldGetText in the QuerySave event of your forms to capture the current display text and store it in another field.