Customize number column to remove the commas and to choose the number of digits needed from the form fillers

The number column works but we need to be able to customize the column recieve a specified number of digits to ensure that the respondents of the forms do not enter the wrong number on the form. For example, when the number required is sjust 4 digits, we need to be able to set the form to recieve only 4 digits after which it will indicate to the respondent that the number is incorrect as it has exceeded the values required

Yeah, I wish Monday’s number column had more options like digit limits and better formatting.

A workaround I’ve used: switch the column to Text for the form, then add a form validation rule or automation that checks if it’s exactly 4 digits. It’s not perfect, but at least you can reject anything too short or long before it’s saved. For hiding commas, text columns also don’t format numbers, so it stays clean.

1 Like