Required Fields

[jennifer28461489ef3d]

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?

[try67]

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");

[jennifer28461489ef3d]

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]

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

[jennifer28461489ef3d]

Where in the code?  I don't know where to put quantity in the code.

[jennifer28461489ef3d]

[try67]

You said it should happen if the selected value is not zero, no? That's what the script above checks.

But your Qty field doesn't look like a drop-down in the screenshot above. I don't see the arrow for selecting values. Are you sure it's not a text field? Could you share the file?

[jennifer28461489ef3d]

I am not able to share the file.  The quantity field is a dropdown from 1-10.  The size and length fields are also dropdowns.  Yes, if someone selects a quantity, of say 2 Red and Navy jackets, they must input the size and length that is needed.

[try67]

The script I provided will do that, if used correctly. If you can't share the file create a dummy file with just those fields and do it there.

[try67]

Keep in mind, though, that the "required" property is only validated when the file is submitted. It has no effect when the file is saved, printed, etc., unless a special script is used to validate those required fields in those events.

[jennifer28461489ef3d]

am I able to send you the file directly without posting in the community?

[try67]

You can email it to [try6767 at gmail.com].

[jennifer28461489ef3d]

Thank you.  I sent it over

[jennifer28461489ef3d]

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