Return live data collection field to null rather than ""

Ask the community
,
1

I have a large collection of data with one text property containing empty cells for most items. I changed the cell of one item to a string of text, but have since needed to revert back to the empty value. However my code is now reading this cell as “”, not null.

Now, I could amend my code so that it also behaves in the desired way for “” values as well as null values, but to me it seems odd that I can’t revert an item’s value back to null in the live database accessed via the dashboard.

Edit: I should also point out that filtering the live collection by “cell is not empty” still returns the item where the cell is empty, i.e. “”.

2

Hi.
when you are getting data from a database you can set all elements that are “” change to null using if statement.

If this doesn’t help to resolve the issue, please send the following details to take a closer look into the issue:

  • What exactly the code should do.

  • Link to your editor.

  • Name of the database collection.

  • Name of the page where the code runs.