Question about empty values when deleting items via Form Editor

Report a Bug
1

I have a question regarding how data is handled when deleting items using the Form Editor.

In my spreadsheet, Columns M and N contain cells where I removed the values using the Glide Form Editor. While these cells appear visually empty, the ISBLANK function returns FALSE.

However, if I manually select the cell in the spreadsheet and press the “Delete” key, ISBLANK changes to TRUE.

Does the Form Editor insert an empty string (or whitespace) instead of truly clearing the value (making it null) when an item is deleted?

cell delete

2

Change the formula to =“”. That works better than ISBLANK

3

I assume you have to get the T and U column values in the spreadsheet/Excel file? If not, it might be a good idea just to use an If-Then-Else column in Glide.