Default a column to the previous value?

[Chris_Hall]

I have a table similar to this:

Date                 Name                       Value1
12/28/2022      Team Member 1      Apple
12/28/2022      Team Member 2     Banana
12/27/2022       Team Member 1     Carrot
12/27/2022       Team Member 2     Celery

What I would like to achieve is the next time I enter a record for a team member to prefill Value1 with the last entry for that team member.
For example, if I enter Team Member 1 on 12/29/2022 Value 1 would be filled with Apple. Likewise, the next entry for Team Member 2 should have Banana for Value 1

[Christiaan_Huizer]

hi @Chris_Hall

I am not sure if you want to use a button to print the value or a formula in the column or a value for new rows.

either way I suggest you create a filter that asks for the last fruit per employee and last defined as the last date using Sort().

in step02 you add Last()

thisTable.Filter(teamMember.Contains(thisRow.teamMember)).Sort(True(),sortBy: thisTable.date).fruit.Last()

hope it helps, cheers, Christiaan

[Chris_Hall]

This worked! Thank you!