How do I set a form field to accept leading zeros in a number?

[lonnier21178614]

I am trying to create a fillable form using Acrobat Pro DC 2018 for Mac. One of the fields asks for the employee number. Some begin with zero, but after entering the number and saving the form, the leading zero doesn't show up.

[Bernd Alheit · Accepted solution]

Set the format to None.

[Saibai40]

Sir,

Setting the format to None, the field will also accept alphabets, and then it is not an 'only number' field. The leading zero has to be displayed in Number field alone. In some of the very earlier versions of Excel, it was easy to choose Number format to 'display' or 'do not display' leading zeros.

R G Kulkarni

[try67]

PDF and Excel are very different things. If you want the field to only accept numbers, but still allow initial zeros, use the following code as its custom Keystroke script (under Properties - Format - Custom):

if (event.change) event.rc = /^\d+$/.test(event.change);

Note that using this code you won't be able to enter the negative symbol, or a comma, etc. Only digits.

[Saibai40]

Sir,
Greatly honoured to get so fast a reply. The code has worked and I am able
to get the leading zero being displayed in the 'Number' only field.
Thanks and regards,
Saibai40

[Private info removed]

[Barbara25808020vdcu]

Thank you for this!!

[NB1347]

I am very new to applying script to Adobe Acrobat Pro 2017  PDF forms. I have a form where I concatnate two fields (WBSProgram & WBSJobcode) into a third (labeled CompleteWBS) for Work Breakdown Structure (WBS) cost accounting codes. A WBS is alphanumeric, can start with a 0 that must be displayed in the final field.

My problem is my final field (CompleteWBS) does not show the 0 in the WBS if it starts with a 0.

this is a correct WBS 

RA.02148956.0123456

my current field would populate this

RA.2148956.23456

Is there a script I can apply to still allow letters and also keep leading 0?

[NB1347]

Correction, There are three fields that concatnate into the fourth CompleteWBS. The first is the WBSType 

in the above WBS example, the RA is the WBSType

[Bernd Alheit]

What script does you use?

[NB1347]

I have three fields (WBSType, WBSProgram and WBSJobCode) that accept user
entry: The WBSType is a dropdown box with options to choose from, the
WBSProgram and WBSJobCode are text fields

I am using JavaScript on blur for the three and javascript. Below are my
script for each field:

*FBMSProjectType -(referenced above as WBSType)*











*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode1"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS1");collatePreSetFieldsTo(five);*










*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode2"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS2");collatePreSetFieldsTo(five);*










*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode3"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS3");collatePreSetFieldsTo(five);*










*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode4"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS4");collatePreSetFieldsTo(five);*


*WBSProgram*











*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode1"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS1");collatePreSetFieldsTo(five);*










*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode2"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS2");collatePreSetFieldsTo(five);*




























































*//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode3"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS3");collatePreSetFieldsTo(five);//this function
popluates the referenced field.function collatePreSetFieldsTo(populate){
//always overwrite the value in populate field with these field values var
one = this.getField("FBMSProjectType"); var two =
this.getField("WBSProgram"); var three = this.getField("WBSJobCode4");
//concatenate populate.value = one.value + '.' + two.value + '.' +
three.value ;}var five =
this.getField("CompleteWBS4");collatePreSetFieldsTo(five);WBSJobCode1 - My
form allows up to 4 unique WBSJobCodes. Each has the script below but
different WBSJobCode2, WBSJobCode3, WBSJobCode4//this function popluates
the referenced field.function collatePreSetFieldsTo(populate){ //always
overwrite the value in populate field with these field values var one =
this.getField("FBMSProjectType"); var two = this.getField("WBSProgram");
var three = this.getField("WBSJobCode1"); //concatenate populate.value =
one.value + '.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS1");collatePreSetFieldsTo(five);My final field
where all these concatenate too is labeled CompleteWBS and is Run
JavaScript On Focus//this function popluates the referenced field.function
collatePreSetFieldsTo(populate){ //always overwrite the value in populate
field with these field values var one = this.getField("FBMSProjectType");
var two = this.getField("WBSProgram"); var three =
this.getField("WBSJobCode1"); //concatenate populate.value = one.value +
'.' + two.value + '.' + three.value ;}var five =
this.getField("CompleteWBS1");collatePreSetFieldsTo(five);I also have a
Custom Calculation script in each WBSJobCode field that hides the
CompleteWBS filed if no data is entered into the JobCode fieldvar bReady =
true; if(this.getField("WBSJobCode1").value.length == 0) bReady = false;
else if(this.getField("WBSJobCode1").value.length == 7) bReady = true;
if(bReady) this.getField("CompleteWBS1").display = display.visible;
else this.getField("CompleteWBS1").display = display.hidden*

[Bernd Alheit]

Your code is difficult to read.

[NB1347]

I agree and I am sure there is a much more simple way to write the script
to get my end results. It is a form for government use and I cannot send
out the entire form. I will see if I can delete all protected info and
email the portion with the javascript code. Would that work?

[Bernd Alheit]

Use a external Javascript editor like notepad++.

[Saibai40]

Hi,
If you want the field to only accept numbers, but still allow initial zeros,
use the following code as its custom Keystroke script (under Properties -
Format - Custom):
*if (event.change) event.rc = /^\d+$/.test(event.change);*
Note that using this code you won't be able to enter the negative symbol,
or a comma, etc. Only digits.

Above post is from Adobe Support Community

[NB1347]

Hi all,

My IT department was able to correct my script. Thank you all for the help!!

[JMC08]

thank you

[lonnier21178614]

Thanks ever so much!!! That worked.