JSON - Format value of a number column to specific number of characters

Question

Hello, I have a number column in a SharePoint list called "PO Number". The PO number is always going to be 10 digits in length. I want to format the field so that the user is required to enter exactly 10 digits, no more and no less. Any ideas on how to do this?

Answer 1

Hi @Sarah B ,

You can limit by column settings.

In Edit column panel, scroll down and extend the More options, enter 1000000000 and 9999999999 for the minimum and maximum allowed values respectively.

Then the data that needs to be entered must be 10 digits.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I was able to accomplish this by using the LEN function in column validation

LEN([Field Name]))=10