Auto fill based on last entry

Hey everyone, I am building my first inventory app, and I need some help with having the ‘add piece’ action remember the last input entered. Ultimately I want to hit save and in the new form have the location field remember and populate the last inventory location entered. Is there a code that can be created? And would it go in the auto compute field? Thanks I’m advance for the help!

INDEX(
  SELECT(
    TableName[NeededValue],
    [_RowNumber]=MAX(TableName[_RowNumber])
  ),
  1
)

One way to do it

1 Like