how to validate the field must be numerical and longs 12 characters?

Question

Dear all,

i have created a custom fields (free text type) called Contract Number, i want to validate when create an issue, user must input the contract number fields with a numerical value and longs 12 characters, how to make it possible? is it from the workflow or any other choice? i have JMWE as and addon or should i change another custom fields type?

Thankyou

Prosper Agwegiokhe · Answer

Hi @Nicolas Andika

Apologies for the late response, and you are correct, the conditional validation must be true for the validation to work.

The approach to take would be to "Build-your-own Validator". I tested with this function:

issue.customfield_10166 != null && issue.customfield_10166.length == 12 && issue.customfield_10166.split('').every(char => char >= '0' && char <= '9')

and it worked as expected. It is also worth mentioning i tested this with the short text (plain text only) custom field as it doesn't seem to work with rich text.

Please try this out and let me know if it resolved your issue.

Regards,
Prosper.

Nicolas Andika · Answer

Hi @Prosper Agwegiokhe

i have tried the suggestion that you shared above, but it seems not working, i think because the conditional validation is for condition that must be true to make the validator work, is there any possible ways to make it happen?

Thankyou

Nicolas Andika · Answer

Hi @Prosper Agwegiokhe

Thankyou for the support, it really helps, one more question, can we validate the value must be numerical?