Row-specific data validation filtering for Dynatables

Current limitation:
In the current spreadsheet setup, all units are available in the unit dropdown - regardless of the activity in the row. For example, for “Natural gas”, users can currently select irrelevant units such as litres, nights, or meters.

Desired behavior:
The selectable units in the dropdown should be restricted based on the activity (row context).

Example:
For the activity “Natural gas”, only the following units should be selectable:

• Tonnes (t)

• Kilowatt hours (kWh)

• Cubic metres (m³)

All other units (e.g., litres, metres, nights, etc.) should be hidden from the dropdown.

Context / Problem:
Even though a data filter (dfilter) is already applied, the unit dropdown still displays all available units (as visible in the screenshot), which:

• Increases the risk of incorrect data entry

• Reduces usability and clarity for end users

• Requires additional validation steps

Value / Benefit:

• Improved data quality (less incorrect unit selection)

• Better user experience (clean, context-relevant options only)

• Reduced need for validation logic downstream

Suggested solution:
Enable row-dependent filtering of dropdown values in Dynatables, so that unit selections can be dynamically restricted based on row attributes (e.g., activity type).