Save a list of values that were true at a given timestamp

[_pete_]

How might one create an expression which renders a list of values from another table which were true at a given timestamp, and then saves that list when the form is saved? More detail:

Imagine I have a table (Attendance) and form that tracks every time a person arrives or departs from a party. Then imagine I have another form for another table (Audit) for auditing the party attendance. Whenever a host wants to they can create a form entry which automatically lists who all is in attendance and they can either confirm that it's true or not, and the result is a row in the Audit table. I have figured out how to show "who's at the party" in the Audit form using a virtual column, with element type=REF, and a SELECT() formula to list the people who are currently at the party. It looks something like this:

SELECT(
Party[Check in ID],
[In Attendance Virtual Column]="Yes",
TRUE
)

The [In Attendance Virtual Column] has this in the app formula:

IF(
[_THISROW].[Check in ID]=MAXROW("Party","_RowNumber",[_THISROW].[Person]=[Person]),
TRUE,
FALSE)

The problem is that when I submit the form the details show the results for the SELECT() formula right now rather than whatever was true when I started filling out the audit form. How do I modify my formula so that the Audit row shows what was true at the timestamp when I filled it out?

[1minManager]

Sounds like you need to make [In Attendance Virtual Column] a regular column of ENUMLIST type.  Virtual columns are always 'live' so they always show the situation now.

Simon, 1minManager.com

[_pete_]

I ended up pursuing another way of capturing the audit, but thank you for this tip; it sounds like the right way to resolve the problem I was encountering. I appreciate your help!