Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Numeric field accepts 10 digits only

Highlighted
cat_gon0208
Super Collector

Numeric field accepts 10 digits only

Hi All,

 

We have a field with validation that is textfield numeric, it only accepts 10 digits.

 

Is there a way that we can increase the maximum value?

Or any work-around that we can apply?

 

Thanks.

 

Catherine

6 REPLIES
Utkarsh_Mishra
Honored Contributor

Re: Numeric field accepts 10 digits only

You can use Text Field (alphanumeric), it allows you to store number greater than 10 digit.

 

Where for Numeric validation/check on this field, you can create custom UI rule; to check whether number enter by the user is numeric or not, based on this can pop-up the appropriate message.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Mohit_Agrawal
Frequent Visitor

Re: Numeric field accepts 10 digits only

Hi Catherine,

 

You can create a new validation with Component Type as "Text Field" and Data Mask as "Custom" and Format as "D".

 

Also, this can be done with Component Type as "Text Field" and Data Mask as "Numeric" and set the maximum value to infinite.

 

Thanks!!

Mohit Agrawal

--Click Kudos if you like the answer.

cat_gon0208
Super Collector

Re: Numeric field accepts 10 digits only

Hi Utkarsh,

 

We have tried this, but then the format is incorrect when stored in the DB.

 

Thanks.

 

Catherine

cat_gon0208
Super Collector

Re: Numeric field accepts 10 digits only

Hi Mohit,

 

How to set the valu to infinite?

 

Thanks.

 

Catherine

Jim Esler
Honored Contributor

Re: Numeric field accepts 10 digits only

Your data validation rule can be set up to remove any non-numeric characters from the field. You can use this kind of rule in place of or in addition to a rule that pops up a warning message. An alternative is to just clear an entry that has any invalid characters in it (along with a message that tells the user what is wrong).

Mohit_Agrawal
Frequent Visitor

Re: Numeric field accepts 10 digits only

Hi Catherine,

 

By saying infinite, I meant to say that you can set it to 99999999999999999999...

 

Thanks!!

Mohit Agrawal

//Add this to "OnDomLoad" event