Settings values in tables not configured as the data source in the screen

[stomgb]

Hello Gliders,

I have two screens, each is sourced to a different source table - Table A (Sessions, with a pk called session_id) and Table B (Tools, with a user specific column called active_session).
As the user interacts with tools, I want to update specific columns in both tables based on a shared value - the unique session id.

For example, a user starts the workflow in table A by selecting a session. I now have the session id at hand and the user email (identifier) and need to set these two user-specific columns in table B (tools). How do I do that?

Second example - when a user selects and interacts with a tool (second screen backed by table B), I’d like to update specific columns in table A (sessios) for that session.

I can store (with a user specific column) the session_id and user_id in the tools table, but then I can’t find an option in the set values action to set a value of a specific row in the sessions table (i.e a table not configured as the data source for the screen).

[Darren_Murphy]

In each scenario, do you need these values in all rows in the other table, or in one specific row?

• If all rows: Use a Single Value Column
• If a specific row: You need to create a single relation from one table to the other, then you can Set Column Values via that relation.

Alternatively, set the initial values in your User Profile row instead, then you can access them from any table/screen.

[stomgb]

Amazing, so helpful!!
As suggested I added an Active Session column to the Users table and also added a Relation column to the Sessions table. Indeed, the User profile columns are always available so this way I am able to go from Users to Sessions to Tools from any screen in the app.

I’ve also updated this thread accordingly.

Thanks!