Skip to main content
Milltrish
Milltrish
Participant
Apr 10, 2020 6:43 PM UTC
Answered

Help limiting an Adobe form field to allow only certain numbers to be entered

Let me start by saying I do not know any coding at all. I'm new to Adobe Pro and I'm trying to create an Adobe form that will be used as a timesheet. The form will have multiple fields where the user needs to enter total hours worked in a day (one field for straight time, another for overtime, another for comp time, etc.). I want to limit the fields to only accept numbers between 0 and 24 in increments of .25. So for example, 8 or 8.25 or 1.5 or 2.75 are all acceptable.

 

If an invalid number is entered, I would like an error message to pop up saying to enter time in increments of .25 and the field to reset to blank. I found code on the internet that worked beautifully but would require me to code every quarter increment between 0 and 24 (including variations such as 1.5 and 1.50 and 2 and 2.0). And the one form has 77 fields (bi-weekly timesheet tracking straight time, OT, Comp Time, vacation, sick, etc.) - I would imaging having 77 fields with that extra long code would just cause a crash or a freeze.

 

I could live without the error message if the field could just reset back to 0 and not allow the invalid entry. Can someong please point me in the right direction? 

This topic is closed to new replies. Start a new post to keep the conversation going.
try67
try67Correct answer
Community Expert
Apr 10, 2020 9:31 PM UTC

If you do prefer to use a text field, you can use this code as your custom validation script:

 

if (event.value) {
	var v = Number(event.value);
	event.rc = (v>=0 && v<=24 && v%0.25==0);
	if (!event.rc) app.alert("You must enter a number between 0 and 24, in multiples of 0.25.");
}

 

View reply

4 replies

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
Apr 10, 2020 9:31 PM UTC

If you do prefer to use a text field, you can use this code as your custom validation script:

 

if (event.value) {
	var v = Number(event.value);
	event.rc = (v>=0 && v<=24 && v%0.25==0);
	if (!event.rc) app.alert("You must enter a number between 0 and 24, in multiples of 0.25.");
}

 

Translate
Milltrish
MilltrishAuthor
Participant
Apr 13, 2020 8:35 PM UTC

Thank you! Your solution worked perfectly! I prefer to use a text box as opposed to drop-down boxes because the form has 77 fields where a user could enter time and feedback from a sampling of users said they preferred to tab through each field and type in a number as opposed to using a drop-down. Again, thank you!

Translate
try67
Community Expert
try67Community Expert
Community Expert
Apr 10, 2020 8:56 PM UTC

Why not use a drop-down field, then? You can set it to only contain valid values, so the user can't make a mistake and you don't need to mess around with scripts...

Translate
Thom Parker
Community Expert
Thom ParkerCommunity Expert
Community Expert
Apr 10, 2020 8:36 PM UTC

Are you interested in learning how to code?  If you want these sepcific increments, then why not use a dropdown that only has these as the selection. Use two dropdowns to keep it to short dropdown lists, one for the hour and one for the minutes.

 

 

Translate
Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices