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,
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.
@Tom_Graham
You can use below expression
NUMBER("")
ahhโฆsimplesโฆ thank you!
Youโre welcome
How to do the same for other types, such as Date, Enum, Ref, Price? neither NUMBER("") nor TEXT("") do not work for those types.
Start with "". For Decimal-derived types (like Price), use DECIMAL(""). For Number-derived types, use NUMBER("").
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".
SOLVED: Even my column was of type "Number", I had to use DECIMAL("") and it worked fine.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |