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.
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)
COUNT(), not LEN().