Avoid rewrite rows in Appsheet

AppSheet AppSheet Q&A
1

Hi,

I`ve been trying to verify if a row in a google sheet (without id) in a determined column is empty.

Example:

IDscanner | Date | Scanner | Product |

221abc |10/11/25 | 28.125/0038 | Shirt Blue |

223sdf |10/12/25 | 28.125/0039 | Shoe BLA |

                        |10/13/25         | 28.125/0036                | Backpack                      |

When the user scan the 3rd row, Apsheet add a number in the column [IDscanner] and rewrite the others columns, deleting the previous data in that 3rd row. How can I determine Appsheet not rewrite that row, or warn the user that row has data, or jump to the next empty [Scanner] row.

Thanks in advice!

2

All rows must have a value in the key column. If they do not, Appsheet will not load this as a data record at all. Newly added rows will always be inserted after the last row that does contain a key value, even if this overwrites data in the other columns.

There is no simple way to do what you’re asking, but maybe if you elaborate on your use-case, another solution may present itself. Why does your 3rd row not have a key value?

3 Likes