Initial value = last value entered

Good day
I have an app to register inventory.
daily I enter several records but most tend to be from the same person in charge, (which I extract from a different table) so every time I have to fill the same field over and over again, occasionally it varies.
I would like to know if there is any way that the initial value of the “responsible” field in my “Responsible” table is the last one that was saved.
Thank you

1 Like

most recent entry: (Edited to reflect Steve’s correction below)

INDEX( Responsible[responsible] , COUNT( Responsible[responsible] ) )

(just one of many different expressions you could use to get the most recent entry)

1 Like

COUNT(), not LEN().

image

2 Likes