Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Input Masking of fields

Topic Labels: Base design
443 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to have an input Mask in the tables / forms? I want a field to be displayed in the format S0123, or another field to be displayed as 4 digits such as 0025 (not simply 25).

Thanks in advance all.

1 Reply 1

If it isn’t a configuration option then no. A workaround would be to use the Currency field type, which lets you replace the default currency symbol “$” with your own prefix so you can insert “S” at the start of your number. That won’t get you leading zeros, however. For that you would need a separate formula field that does something like: REPT(0, 4 - LEN({Number field}&"")) & {Number field}