Initial Value & Multiple Users Issue

[JonnyRocket]

I have a dropdown that I pre-populate with the most recent entry which works great, except when there are two different people using the app and they are working on two different items. It just jumps to the most recent entry (like it is designed) Is it possible to make this work based on the current users most recent entry. This is what is current set for initial value: I’m struggling to figure out how to select this based on the current user. I do have a column that includes the users email for each entry. Any ideas?

[Steve]

How does the MostRecent column get its value? Please post a screenshot of the expression used.

[Marc_Dillon · Accepted solution]

Something like this will probably do the trick:

MAXROW( Table , “_Rownumber” , USEREMAIL() = [Email] )

help.appsheet.com

MAXROW()

Row with greatest value in column

[JonnyRocket]

Thank You. I was able to adapt this to my app and make it work. Thanks!

[JonnyRocket]

Thank you! This sent me in the right direction. I completely forgot that there was a MostRecent column that actually figured out the most recent.