Repeat last entry?

STS_Reads · 10-04-2019 06:49 AM

I have a data entry form with a couple items that may not change. Is there a way to have the add new form to always default to the entry on the previous entry for those 2 items? Basically I would like it to stay the same until changed .
Thanks

Steve

A suitable Initial value formula will do this for you.

STS_Reads

It just might, I’ll try it out.
Thank you

STS_Reads

Any thoughts on what that expression would look like?

Lynn

Another option that may or may not be useful in your case is an action to “Copy and edit this row”

Steve

Assuming the last entry corresponds to the row of your spreadsheet with the highest row number (typically a good assumption), the following expression will give you a Ref to that highest-numbered row:

MAXROW("MyTable", "_ROWNUMBER")

replacing MyTable with the name of your table. You could add a (normal, not virtual) column to your table with that as the initial value expression, then you can dereference that column to get column values from that last row.

STS_Reads

I tried using
MAXROW (“unit list”[Property], “_ROWNUMBER”)
but that is giving me the the row number not what was previously entered in the row.

Steve

As I said:

The value you got is a Ref. Read more:

I then suggested:

I continue to suggest that.

Finally, you said:

which means _ROWNUMBER is your key column, which is a bad idea. From What is a Key?:

The row number is not a good key. If entries are moved or deleted, or if users add or delete entries simultaneously, the row number for each row will change and there is no way for AppSheet to uniquely identify the row. The Editor will give a warning if row number is chosen as the key.