Copy link to clipboard
Copied
I imported an excel spread sheet form into adobe. It did not bring across the drop downs and the "equal to" .
IIhave reconstructed the drop downs but now I need the selected from the drop downs to auto fill the cells on the next form.
How do I do this??
Copy link to clipboard
Copied
Fields and equations/calculations are not carried over when converting from Excel (or any other Office format) to PDF. They have to be re-created in the PDF from scratch.
To populate a text field from a drop-down selection you need to use a script. This is the basic code (to be used as the custom Validation script of the drop-down field):
if (event.value=="Option 1") {
this.getField("Text1").value = "Some text for Text1";
this.getField("Text2").value = "Other text for Text2";
} else if (event.value=="Option 2") {
this.getField("Text1").value = "Some other text for Text1";
this.getField("Text2").value = "Other other text for Text2";
} else {
this.getField("Text1").value = "";
this.getField("Text2").value = "";
}
Adjust the field names and values in the code as needed, of course.
Copy link to clipboard
Copied
Ok that is not working. Here is a pic of what I want to do. The info from column Track Style & colour page 1 too Track Style & colour page 2
Copy link to clipboard
Copied
Can someone answer this question or do I need to submit another request???
Copy link to clipboard
Copied
If you want help you need to provide details. Just saying "it doesn't work" is not very useful to us.
Copy link to clipboard
Copied
Check the Javascript console for errors (ctrl-j).
Copy link to clipboard
Copied
I have no idea how to write Java script I do not understand what I am supposed to write.
all i want is the answer in a drop down from one form to mirror in another. As per the screen shot.
So I guess I am the error!!!
Find more inspiration, events, and resources on the new Adobe Community
Explore Now