Hi appsheet,
when a user deletes a row from a table, it is also deleting the data in the row in the google sheet, but can it also remove the row in google sheet? Is this an option to select in google sheet?
thx a lot, Bram
When your app deletes a row, it leaves an empty row
The reason for leaving the empty row is that weโre not sure what other logic you have in your sheet. For example, some people have positional formulas and removing a row could mess things up
I understand the logic. Is there an option to choose if we want to empty or remove the row?
@praveen makes sense, but can it be made an Option please. Lots of additional admin in the sheets that one would want to avoid
Do you mind adding this to appsheet.com - Login - AppSheet โ it is the central spot where we manage all feature requests from customers (and provide feedback as well). Login - AppSheet appsheet.com
@Diogenes_ASBL_VZW will you log as you started the post. We will UpVote if you past the link here
Just following!
Any movement on this? I am also in need of a solution to remove empty rows after deleting in appsheet
Hi Liz,
You can periodically remove the empty rows from you worksheet manually if you wish.
However, never do this if your table uses row number as the key and you have a Ref in any other table that references the table having empty rows. If you are uncertain about this, do not manually delete the empty rows from your table. Doing so risks damaging any References to the table containing the empty rows. Fixing damaged references can be very difficult.
To manually delete the empty worksheet rows:
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |