45

Product Tip: How to format the output of a Number Field

Letโ€™s say you have a process named New Employee Salary Account Details which you use to gather the bank account details of new employees and set up their salary accounts. In order to collect the bank account numbers without any errors, you might use a number field. But since data in number fields are separated by commas by default, this isnโ€™t an ideal solution.
Therefore, you can use a text field and add a validation that allows only numbers to be entered in the field. To do this,
1. Select the text field you wish to use as the bank account number field.
2. Go to Validation โ†’ Add a validation rule โ†’ select Numbers only.

This way, you can ensure that the employees only input numbers into this field. Every time an employee inputs a non-numeric value, they will see the following default error message: Value must be numeric.
Pretty simple, right? React to this post if this was helpful! 
Tell us what our next tip should be about.

Content aside

  • 45 Likes
  • 2 yrs agoLast active
  • 98Views