Action to set a Number field to be 'blank', instead of 0

[Tom_Graham]

I have Number fields that I want to make “blank” (not Zero), using an Action.
However whatever I try, I cannot get an action to “clear” a value (make the field ‘blank’). It will always revert to adding a 0.

It works for Text fields… obviously… but not for Number fields

Is there a way to make a Number field revert back to being blank with Appsheet?
I can see why perhaps not, but it’s allowed in the first place so you would think you should be able to do it, without reverting to clearing from the data source itself.

Thanks,

[Koichi_Tsuji]

How did you constrct your action ?

It should work

Please try to pass the value of “”

to the data field you want to clear up and leave back to null.

[LeventK]

@Tom_Graham
You can use below expression

NUMBER("")

[Tom_Graham]

ahh…simples… thank you!

[LeventK]

You’re welcome

[BLAWQE]

How to do the same for other types, such as Date, Enum, Ref, Price? neither NUMBER("") nor TEXT("") do not work for those types.

[Steve]

Start with "". For Decimal-derived types (like Price), use DECIMAL(""). For Number-derived types, use NUMBER("").

[cboteros]

Maybe this used to work before or only works for Spreadsheet databases, because I'm trying now in 2023 while using an Appsheet database, and I'm always getting a "zero" instead of "blank".

[cboteros]

SOLVED: Even my column was of type "Number", I had to use DECIMAL("") and it worked fine.