Must have happened to many... I have a number field which I want to treat as boolean (0 or 1). In the layouts I am using a check box set with only one option, or a radio button set with 2 options. in the radio button set I have 2 alphanumeric options, say "Confirmed" or "Not confirmed". Upon selection of the radio button, I select one of these text values but not the 0 or 1 I need to store. How can I transform them? Is there an easy and efficient way?