Get currently selected row of another widget

Hello together,
i have users needing to add rows to a third widget based on currently selected record of two other widgets. The aim is to speed up adding data by letting users select their “name” and current “issue” in a first and secound widget.

With the “SELECT BY” mechanism i can only bind to one other widget.

I thought as alternative to create a trigger formula that fills the column in the third widget with the content of the row selected in another widget.

How can I retrieve which record is currently selected in a widget?

3 Likes

Add a trigger formula:

value = selected_row.Table_you_want_the_value_from.Column_you_want_the_value_from
return value