Jul 28, 2021 4:42:56 PM
Feb 17, 2021 11:01:50 PM
When entering a decimal value that ends in one or more zeroes, the trailing zeroes will be removed if the value is entered in an input field that expects a string value.
To prevent this, add an " " to your value.
Example: If you enter the number 30.70 in a string input field, the last 0 will be trimmed automatically and the output will be 30.7. In some cases, this last zero is needed for example, for a project or product code. Hence you need to add " " to your value so that the last 0 will not be trimmed.
When entering 0 as a value for an input field, encapsulate it in double-quotes "0", else it will be considered as null. Also you can use "To text" formula to convert the number to string.
Click here to find the formula placeholders.
Before adding " "
After adding " "
