Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
10

importing excel forms to adobe and associatied problems

New Here ,
May 12, 2024 May 12, 2024

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??

TOPICS
Edit and convert PDFs
616
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 13, 2024 May 13, 2024

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 13, 2024 May 13, 2024

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

jamie37352569m5e4_0-1715652209774.png

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 15, 2024 May 15, 2024

Can someone answer this question or do I need to submit another request???

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 16, 2024 May 16, 2024

If you want help you need to provide details. Just saying "it doesn't work" is not very useful to us.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 16, 2024 May 16, 2024

Check the Javascript console for errors (ctrl-j).

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 19, 2024 May 19, 2024
LATEST

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!!!

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines