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

AppSheet AppSheet Q&A
1

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,

2

How did you constrct your action ?

It should work

3X_b_3_b3f3d60612ce843c16a7c6522bd2750a83a49b40.png
3X_b_3_b3f3d60612ce843c16a7c6522bd2750a83a49b40.png744×301 15.5 KB

Please try to pass the value of “”

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

3

@Tom_Graham
You can use below expression

NUMBER("")
10 Likes
4

ahh…simples… thank you!

5

You’re welcome

1 Like
6

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

7

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

2 Likes
8

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”.

9

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