Looking for a way to remember the value in a previous row

AppSheet AppSheet Q&A
1

I have an app that allows the user to enter data rows very quickly. In order to be as quick as possible, I would like to set a field to have the same value this user entered in the previous data row.

I thought of using User Settings, but I read that this cannot be updated during a row save. I also tried a “cache table”, where I saved the user email and the value selected, (and then used that as the default in the field), but that also did not work.

Any other ideas?

Thanks

2

LOOKUP( MAXROW(

1 Like
3

Thanks for the response. I tried the following in the Initial Value, but it did not populate the field. Any idea why?

ANY(SELECT(Disk Drive Info[Model],
[_THISROW].[_ROWNUMBER] = MAXROW(“Disk Drive Info”, “_ROWNUMBER”,
([Created By] = USEREMAIL())),
true
)
)

Scott

4

MAXROW returns a key value. I really hope you’re not using rownumber as your key column.

Also, remove the [_THISROW], you’re not comparing against the current record, you’re trying to find which record’s key value matches the one returned from MAXROW.

3 Likes
5

Ah, that did it. Did not realize that MAXROW returned the key, thanks.

2 Likes
6

MAXROW() - AppSheet Help