Data validation issues in the newly created Request Form

[Banajyotsna palbabu]

Hi All,

We recently created a new Request form for the customer portal and realized the data validation for the form fields are not working as expected. For example for a numeric field (like Batch ID) we want to limit that to min- 5 and max - 9 digits. But it is not working as expected. Can you please advise? TIA.

[Ste Wright]

Hi @Banajyotsna palbabu 

Can you clarify what is not working? It's be great if you could provide:

1. How you built and tested the validation
2. What you expected it to do
3. What it actually does

This will help us investigate and help further!

Ste

[Banajyotsna palbabu]

Hi Stephen,

We created a custom Request form from scratch and attached it to a request type in the portal. Also added fields like user ID as Number and in the "Validation" field (right side panel) Minimum we entered 5 and Maximum 10. We thought it will enforce the users to enter numbers which is minimum 5 digits. for example when a user enters a number like 1234 it would not take it but if he enters 12345 or 123456 , it would accept it. That is not working. 

Our goal here to create a numeric field which will enforce the users to enter a value which is between 5-10 digits. Please advise.

Thanks

[Ste Wright]

Hi @Banajyotsna palbabu 

It's sort of possible with a number field.

It's not possible to set a min/max character limit, which is what you need - but you could set...

• Minimum: 10000 - i.e first number with 5 digits
• Maximum: 9999999999 - i.e last number in a 10 digit series

---

Alternatively, you can set character limits using a text field type, such as Short text - you could then...

• Set Minimum/Maximum characters
• Set the Validator Must match regex pattern
• Use regex to ensure it's numbers only...
  • Pattern - ^[0-9]*$
  • Message - Please enter numbers only

---

The only limitation with the alternative is that if you're mapping to a Jira field, it has to be a text field. There is a workaround though...

• Create a custom short text field
• Link this field to the form
• Use Automation to copy the data in the text field, to your number field, during Issue creation

---

Let us know which of these options works best for you!

Ste

[Banajyotsna palbabu]

Thank you, Will try and let you know.

[Ste Wright]

Let us know how it goes :)

Ste