I have asked this question before but I think my understanding of appsheet has improved enough for me to better explain my question.
I have a I have a table called “Sessions” that has the following columns
Session ID (Key for this record)
Client (Client id for this session)
Assigned Objectives (Virtual column listing all of the assigned objectives for this client from a table called “Assigned Objectives”)
“Assigned Objectives” has a behavior that opens a new form for a record in the table “Objective Utilizations” filling in data from the “Assigned Objectives”
Selecting one of the rows in “Assigned Objectives” opens a form and enters the data for a new “Objective Utilizations” record.
I would like to also pass the “Session ID”
In PDF Templates you can do something similar with a [_ThisRow-1] to access a grandparent record.
But that ([_ThisRow-1].[Session ID]) does not work with the expressions I enter for the behavior.
Is there a way to access this grandparent value in the expression for the bahavior?
I already have a quasi solution that I use at present (Detailed below) but it I think there must be a more elegant way to accomplish this.
A behavior when the session is opened that sets a status column in the current record column to true after setting any other trues to false.
Then the “Assigned Objectives” behavior sets the “Session” column in “Objective Utilizations” to the value returned by doing a lookup for the row in “Sessions” that has true set as its status. But this adds two extra sync actions.