LOOKUP values from this column in the last meeting for this club

[StephenMattison]

Howdy!  In my Meetings table, [Pick Roles] Initial Value, I need to LOOKUP the values entered into [Pick Roles] from the last meeting scheduled for this club, many clubs will schedule many meetings. My Key column is _ComputedKey.

I have a Meetings table. In the [Pick Roles] EnumList column, User will pick which meeting roles need to be filled while scheduling the next new meeting.  The list of Roles to be filled will mostly remain the same from meeting to meeting,   but will need to change occasionally. So when scheduling a new meeting, I want to set the Initial Value of [PickRoles] to the same as it was for the last meeting, for that club. Then user can add or remove roles as necessary when setting up the next meeting.  TYVM!

[Suvrutt_Gurjar · Accepted solution]

I think you may need to do this in two stages. Something like below

1. Please add a column called say [LastMeeting ID] with an expression something like 

MAXROW("Meetings", "Meeting Date", [Club]=[_THISROW].[Club])

This will give the reference to the latest meeting for that club.

2. Then the initial value for [Pick Roles] can be  something like 

[LastMeeting ID].[Pick Roles]

[StephenMattison]

Thank you, but why couldn't I just use the MAXROW in my Initial Value expression? I just now entered this expression.

SELECT(Meetings[PickRoles], [Club] = [_THISROW].[Club])

I got this expression to work, but it returns all values in all of the [PickRoles] columns for that club. I only want the values that are in the last meeting by this club. Seems like this expression with the MAXROW part added should work.

TYVM!!

[Suvrutt_Gurjar]

MAXROW() only gives the key value ( reference) 

MAXROW() - AppSheet Help

I believe one could alternatively build a single expression but it will be extremely  sync expensive ( A SELECT() within SELECT())  and somewhat complex expression, something like below.

SPLIT(ANY(SELECT(Meetings[PickRoles], AND( [Club] = [_THISROW].[Club], [Meeting Date]= MAX(SELECT(Meetings[Meeting Date], [Club] = [_THISROW].[Club])))),",")

So you may want to consider earlier suggestion of two column approach.

[StephenMattison]

I have already set up your initial 2 column solution and it is working perfectly! Thank you so very much, you're the BEST! Marked as Solution above. Thank you for this kind reply to my not smart question. You are very smart to consider "sync expense" with every step.