Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Input Masking of fields

Topic Labels: Base design
Solved
Jump to Solution
2118 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Pete_Lindley
6 - Interface Innovator
6 - Interface Innovator

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.