I wonder if it's possible to have a set of boolean fields where only one per row can be true, with all others false? I started out trying something like
if field1 = true then false else ...
But find myself struggling to work out what would follow that, whilst keeping an even distribution of true/false across all fields.
Essentially what I'm trying to emulate is a list of questions in an assessment where the person being assessed can only answer "Yes" (true) to one of the questions.
Am I attempting the impossible? Any help appreciated!