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
Input Masking of fields
+9Best answer by Kamille_Parks11
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}
+27If 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}
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.