nuBuilder Forum

Hi

I have a select field, with the options created in list, e.g. 0|Male|1|Female
This works fine in the Edit form

On the Browse form though, the values are shown as 0 or 1 rather than showing Male or Female

How to display the Male/Female on the browse screen and not the list 'index #'

Thanks

Hi Marvo,

open the form properties, select the Browse tab and wrap your gender column name by the IF SQL statement (https://www.w3resource.com/mysql/contro ... nction.php):
The next possibility would be probably the custom PHP code in Before Browse action.

Hope this helps

Thank you! That worked! However, I have other select fields that 5 or 6 options in the list. I can't use IF this. .... else this...

Is there a similar SQL statement that checks multiple values
if it's 1 then this, if it's 2 then this, if it's 3 then this, if it's 4 then this .........

Thank you!

Either replace the list with an SQL that pulls the values from a table and then use a join in the browse to retrieve the description for the values or use multiple replace() like

Thank you - sorted!