Hi appsheet, when a user deletes a row from ...

[Diogenes_ASBL_V]

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

[Fernando_Lopez1]

When your app deletes a row, it leaves an empty row

[pravse]

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

[Diogenes_ASBL_V]

I understand the logic. Is there an option to choose if we want to empty or remove the row?

[Henry_Scott]

@praveen makes sense, but can it be made an Option please. Lots of additional admin in the sheets that one would want to avoid

[pravse]

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

[Henry_Scott]

@Diogenes_ASBL_VZW will you log as you started the post. We will UpVote if you past the link here

[Sdfaheemuddin]

Just following!

[PeakPerformance]

Any movement on this? I am also in need of a solution to remove empty rows after deleting in appsheet

[Phil]

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:

1. Ensure that all of your clients have submitted all of their pending changes.
2. Ensure that no one is using the application.
3. Make a copy of the contents of the worksheet. This will allow you to recover your data, if need be.
4. Manually delete the empty rows in your worksheet.
5. Do a “Sync” through your application to read the updated table data from the worksheet.
6. Verify that you are seeing all of the expected data in the updated table.
7. Verify that any tables that Reference the updated table are working correctly.
8. Try a simple add and update to the updated table through your application to verify that both add and update work correctly.
9. Have all of your clients do a sync to retrieve the updated table. Ensure they are seeing the expected data in the table.
10. Resume normal application operation.