Hello!
I format a column in the spreadsheet side that allows me to give a “0” in front on the numbers. How can I do the same in appsheet side?
In my country if we need to call a mobile phone we dial “0” befor the mobile number, so I need to show that “0” in the appsheet side.
If the column type is “Phone”, we automatically prefix the phone number value with a single quote when the phone number value starts with either zero (0) or plus (+).
The single quote preserves the leading zero. It also prevents the leading plus from
being treated as a worksheet formula.
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |