Q9. How to pull data from dropdown box field to a text field?
You need to add a SQL script in the text field first.

doFieldSQL("
select
case
when $main.areyouhungry$ = 0 then 'A'
when $main.areyouhungry$ = 1 then 'B'
when $main.areyouhungry$ = 2 then 'C'
when $main.areyouhungry$ = 3 then 'D'
end as vtext
")
0,1,2,3 are the field value

Hereby with the sample result:


PreviousQ8. How to make the selection in main table's field same with the details table's field?NextQ10. How to let the users able to see the file uploaded previously, after changing the permission?
Last updated