Editing: exception logic for selectbox predefined values#504

Example: Added off-road vehicles would automatically categorize as 4WD, no need to manually change every time from the default front wheel drive.

In other words, ability to add exceptions to the default pre-selected value.

Detailed example, single-value selectboxes:

Column 2 normally has value “A” pre-selected and column 3 has value “B”.

If the editor user selects “Y” for column 1, then columns 2 and 3 automatically change to “C” and “D”, respectively.

If the editor user selects “Z” for column 1, then columns 2 and 3 automatically change to “R” and “S” instead.

No other column 1 values than “Y” and “Z” trigger any changes to other column pre-selected values.

A possibility like this would reduce the amount of needed editing input in many scenarios.
For example, if we have a main category and subcategories to be selected, the logic could pre-select the most popular subcategory automatically upon selecting the main category.
A significant benefit could be seen when two or even more changes would be triggered upon one selection, and depending on the nature of the data, those values might often not need any further changes, so the editing user could directly proceed to other columns.

The exceptions could be defined in the column settings.
There could be the default pre-selected value like it already has, but below that the exceptions could be added using selectboxes.
Using the values in the above example, column 2 would have:
Predefined value “A”
except
column 1 has “Y” then “C”
column 1 has “Z” then “R”