Change yes/no to 1/0

Any quick way of doing this? Where the user selects Yes or No, but the table saves 1 or 0 instead?

0 1 164
1 REPLY 1

To create quick table with two column, like

ID Label
1 Yes
0 No

Set ID column as key, and Label as label for the table.

For your source column where you can to capture the data, then set data type to ref and reference table is made to this newly created table.
Rather than setting this data type to REF, better approach would be to set to Enum and base type ref, and pass QuickTable[ID] for valid IF.

Just as a one possible workaround.

Top Labels in this Space