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:

Last updated