Hi - I've tried all sorts of things but haven't managed to achieve the following.
I have a character field that takes a variety of entries. I want to be able to have abacus look at this field to find a particular entry, and then write to a yes/no tick box if that entry it true ( or false).
For example, if the 'status field'= 'volunteer', then abacus would fill in a yes or tick value in a tick box.
How can I do this? I keep getting syntax errors and I suspect it is because one field is a character field and the other a bit field. Is there a workaround?
Any help appreciated, Steve

[your_yes_no_field] = 1
should tick the checkbox

[your_yes_no_field] = 0
should untick the checkbox