Jan 10, 2022 12:37 AM
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.
Solved! Go to Solution.
Jan 10, 2022 09:28 AM
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}
Jan 10, 2022 09:28 AM
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}
Jan 08, 2024 07:20 AM
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.