Is it possible to choose a default value for a
select_one question type depending on another
Let’s say I have a
select_one question called “category” with the following possible values pulled from
- Cat A
- Cat B
- New Cat
Then I have another
select_one question called “status” with the following values:
- Not Changed
If a user choose “New Cat” for question “category”, I’d like to set “status” to “New”. If the “category” is not “New” (e.g. Cat A, Cat B…), then I’d like to set the default value for “status” to be “Not Changed”.
However, this should happen only once, so that user can change the default value.
If I use a calculation for “status” field, it will always change the value to either “Not Changed” or “New”. I tried applying
once() function, but it didn’t work. I tried also adding the calculation expression to the “default” column, but it is not working either (looks like calculations are not supported for “default” column).
Can anyone think of a workaround? Thanks