Can I solve this without a session variable?

[teambelair]

Hi All,

Looks like there is no session variable capability in Appsheet:

• Background Variable Table
• Set value of usersetting by action
• Hello! Is it possible to save a value in a "s...

I wonder if I can solve my problem without it. See video:

drive.google.com

2021-07-11_12-08-53.mp4 (video)

Google Drive file.

Data model:

In summary, when the user clicks on a Class, I would like to set the selected class in a session var. Then when viewing Lesson Techniques, the status will be retrieved based on this session variable.

I tried the method 2 from Matt: Background Variable Table but it was too slow and too heavy on the DB.

I can’t find any alternatives other than creating a dedicated UX view per class to capture the context. This is clearly not a good solution since i will have to continually update the list of UX views whenever I add classes.