Lotus Notes: Dialog list multiple column display

Question

I'm trying to perform a multiple column view in a dialog list prompt using a @DbColumn command and did that successfully by adding another column in a view where my dialog list is looking up. The column value in it is something like this: SiteNum + SiteName + State, a combination of my first 3 columns.

Now, is there any way that I can only select "SiteNum" column and have that as my dialog list field value?

I got it working with the help of @Richard and @Ken. I made my formula like this, SiteNum + SiteName + State + "|" + SiteNum. But the problem is that when I select one, the SiteNum only stores on the backend and the field displays the whole selection (e.g 0006-USNY) it should only be the SiteNum (e.g 0006)

I hope you can help me. Thanks!

Answer 1

You should be able to set your formula to SiteNum + SiteName + State + "|" + SiteNum. That will tell the dialog lis to display SiteNum + SiteName + State but return the alias value SiteNum.