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
1 Like
A suitable Initial value formula will do this for you.
1 Like
It just might, I’ll try it out.
Thank you
1 Like
Any thoughts on what that expression would look like?
Another option that may or may not be useful in your case is an action to “Copy and edit this row”
1 Like
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.
2 Likes
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.
As I said:
Steve:
the following expression will give you a Ref to that highest-numbered row
The value you got is a Ref. Read more:
I then suggested:
Steve:
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.
I continue to suggest that.
Finally, you said:
STS_Reads:
that is giving me the the row number
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.
1 Like