Multiple Columns in a SelectBox

Use this board to ask questions or have discussions with other Genie users.
Post Reply
thawley
New User
Posts: 2
Joined: Thu Jun 06, 2019 1:30 pm
First Name: Tom
Last Name: Hawley
Company Name: HOM Furniture
Address 1: 10301 Woodcrest Dr NW
City: Coon Rapids
State / Province: Minnesota
Zip / Postal Code: 55433
Country: United States
Contact:

Multiple Columns in a SelectBox

Post by thawley »

Hello,

I am trying to show multiple columns in a selectbox and return a single value and it is not working. I have two fields selected in the choice options field and the return field in the choice values field, but the only thing that displays in the box is the first field in the choice options field parameter. See attached screen shots, in the properties I selected to display employee name and number but only name is showing. Is there a way to display multiple columns in Genie? Or is this only available in the Rich screen display.

Thank you,
Attachments
Results.png
Results.png (9.8 KiB) Viewed 1577 times
Properties.PNG
Properties.PNG (17.6 KiB) Viewed 1577 times
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Multiple Columns in a SelectBox

Post by Scott Klement »

What happens if you change the 'choice options field' to something like this?

Code: Select all

TRIM(SLNAME) || ' ' || SLSMN
Does that work for you?
thawley
New User
Posts: 2
Joined: Thu Jun 06, 2019 1:30 pm
First Name: Tom
Last Name: Hawley
Company Name: HOM Furniture
Address 1: 10301 Woodcrest Dr NW
City: Coon Rapids
State / Province: Minnesota
Zip / Postal Code: 55433
Country: United States
Contact:

Re: Multiple Columns in a SelectBox

Post by thawley »

That worked great. Thank you.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest