I’m trying to put a conditional text field in a form for a database without success.
I’ve inserted a field (functions > conditional text) and added the condition ‘RA_db.Jobs.haz2 == 1’ as the condition referencing a tinyint value in the database which is linked to a checkbox on the same form, the ‘THEN’ and ‘ELSE’ appropriately filed but nothing occurs.
The checkbox alters the database value as I’ve got an additional textbox that references the same database field in the form and that does change.
I’ve tried many combinations but nothing seems to work. Are conditional text fields meant to work in forms, updating as I change options on a form?
Any guidance would be appreciated.