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,
Multiple Columns in a SelectBox
-
- 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
- Attachments
-
- Results.png (9.8 KiB) Viewed 1577 times
-
- Properties.PNG (17.6 KiB) Viewed 1577 times
-
- 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
What happens if you change the 'choice options field' to something like this?
Does that work for you?
Code: Select all
TRIM(SLNAME) || ' ' || SLSMN
-
- 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
That worked great. Thank you.
Who is online
Users browsing this forum: No registered users and 1 guest