Masks (Advanced options)

The mask option can be used to format the cells within your spreadsheet. This can also be used to only allow certain characters to be inputted. (for example, if you only want numbers, you can just set the mask to "0")

You can add your own text (for example, a "$") followed by one of the mask options below.

Example

{
   "id": "price",
   "header": "Price",
   "order": 2,
   "type": "text",
   "mask": "$ #,##0.00"
},

Mask options

Method	Description
a	Any letter
0	Number
0 liters	Number
0%	Percentage
#,##0	Currency
$ #,##0.00	Currency with decimal
$ #.##0,00	Currency with decimal
dd/mm/yyyy	Date
hh:mm	Time
yyyy	Year four digits
yy	Year two digits
mm	Month
dd	Day
hh24	Hour 24
hh	Hour 12
mi	Minutes
ss	Seconds
\a	Letter "a" (escape for a)
\0	Number "0" (escape for 0)
[-]	Number signal (- or +)

Advanced masking combinations

0 
0.00 
0% 
0.00% 
#,##0 
#,##0.00 
d-mmm-yy 
d-mmm 
dd/mm/yyyy 
mmm-yy h:mm AM/PM 
h:mm:ss AM/PM 
h:mm 
h:mm:ss 
m/d/yy h:mm 
mm:ss 
[h]:mm:ss