Required Fields

Forum|Forum|3 years ago
February 17, 2023
2 replies
3949 views

I have an Excel sheet with formulas that I converted to a PDF. In the Excel sheet I used the formula '=IF(NOT(ISBLANK(A5)), "Please select the size", ""). The first field on the PDF has a dropdown box for quantity (0-10). If a user selects a quantity, other than zero, they are required to fill out the size and length fields. How do I make the size field and the length field required if a quantity higher than zero is selected?

This topic has been closed for replies.

J

jennifer28461489ef3dAuthor

Known Participant

am i able to share this file with someone directly and not post to the community? i still dont have it working.

try67

Community Expert

As the custom Validation script of the drop-down you can enter something like this (adjust the field name as necessary, of course):

this.getField("size").required = (event.value!="0");

this.getField("length").required = (event.value!="0");

J

jennifer28461489ef3dAuthor

Known Participant

Please forgive my ignorance. If the dropdown field is named Quantity where would I put this in the script so that size and then length are mandatory fields?

try67

Community Expert

Nowhere. You only need to specify the names of the other fields in this code.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded