Help

Re: Input Masking of fields

Solved
Jump to Solution
1549 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Pete_Lindley
5 - Automation Enthusiast
5 - Automation Enthusiast

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 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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}

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

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}

paulo
6 - Interface Innovator
6 - Interface Innovator

We have created a form that allows you to mask the text in a field. It is a third-party form that integrates with Airtable.