users' action result could update a dashboard variable's value

[alpglide]

I have a simple table with three columns: country, city, and population. In the Add/Edit form, the country field is a dropdown (select type), with its values retrieved from the following query:

SELECT DISTINCT country FROM mytable

My question is how to dynamically set the options for the city dropdown based on the selected country. I tried using the query:

SELECT DISTINCT city FROM mytable WHERE city = '${payload.country}'

However, this query does not seem to work. How can I achieve the desired functionality?

I know "SELECT DISTINCT city FROM mytable" will fill options in city's dropdown, but "Toronto" should not show up when users choose "US" in country column already.

[alpglide]

I might redefine this as a new feature requirement: When a user selects a row or makes a selection of a column in edit/add mode, their selection could update a dashboard variable's value. This functionality could unlock numerous possibilities.

[vitPinchuk]

@alpglide Thank you for your question

To achieve change variable use data-links functionality

21.02.2025.12.15.47.webm

Clicking on the cell will replace the variable from the field you specified

It is not yet possible to change a variable via Select in edit mode

[alpglide]

thank you for your help.
yes, datalink was the way we used to edit the data by combining business-form and regular table when there was no business table yet. Clicking a link in regular table would change the var-id in the dashboard by datalink, then use var-id to CRUD a row through business-form.