Setting a form field to auto fill based on another field

[DJcohn]

I am creating a scorecard to be used by my companies inside sales group.

I need to set the form so that if data is entered into one field, a specified number will automatically populate in another field.

Example:

IF a "Follow-Up Quote #" field is filled in THEN a 3 will automatically be entered in the corresponding "Pts" fiield

IF a "New Prospect - Customer" field is filled in THEN a 10 will automatically be entered in the corresponding "Pts" field

IF a "New Quote #" field is filled in THEN a 5 will automatically be entered in the correspondng "Pts" field

Sample Form below for visual

[blendseasy1]

I am trying to write some script for a field in a PDF.  I would like the information in several fields to all populate into one field all together. 

I would like the Text 32 box to automatically start with a U and then the information that is entered in the fundcode, dept, projectgrants, program to all populate together after the U.  For the Account box I would like that entry to equal a letter and enter that at the end of the string in the Text32 box.  Ex.  if 1005 is entered in the account box, the letter S would populate at the end of the string in the Text 32 box. 

Would someone be able to guide me?

[traceyc28668387]

This thread sound close to what I'm looking.  If anyone could help I'd be super grateful

I created a drop down list called 'Employee List' to auto populate to 2 different text fields, 'Employee Name/ID1' and 'Employee Status1', that part I've got.

When picking from the 'Employee List' and 'Regular' auto populates to the 'Employee Status1' the number '1' will auto populate to another text field named 'PayTypeStatus1'.  If 'Temp' auto populates to 'Employee Status' the no '2' will auto populate to 'PayTypeStatus2' etc

The other step involves a separate drop down list called 'Acting Rate'.  If an acting rate is picked it will need to override the Regular or Temp Status auto populated from 'Employee List' to say 'Acting', then 'Acting' will auto populate the number'11' to the 'PayTypeStatus' text field.

One more thing, if 'Auxiliary' auto populates to 'Employee Status' from the 'Employee List' the number 3 will auto populate to 'PayTypeStatus' BUT if an acting rate is chosen the status needs to stay '3', not '11' as described above.

[JainSa]

Dear Experts,

Needed your help. above the table when the quantity value comes with 0 the column will be color on "red".

here how to write the script code based on the condition in Adobe LiveCycle designer form calc or javascript.

[jenniferk69559934]

Hi all!

I am creating a form and need to auto fill a field based on a selection in another field. For example: If I select the Common Name from a drop down list, I need the Botanical Name to auto fill.

Any help would be greatly appreciated!

[try67]

Read this tutorial: https://acrobatusers.com/tutorials/change_another_field

[sl113]

I have a similar question with EllenBBC but the code doesn't seem to work for me. I have a field (Field 1) that auto calculates the sum of other fields. I would like to have a separate field that generates text according to the number in Field 1.

Field 1 will be calculated and the number can range from 0-40. I would like to text to be generated as

< 14 "Unsatisfactory"

15-22 "Below Requirement"

23-29 "Meets Requirements"

30-35 "Exceeds Requirements"

36-40 "Outstanding"

I tried to use answers above to modify it accordingly but it doesn't seem to work.

Thank you!

[try67]

Post the code you used, please.

[sl113]

var v = this.getField("Field 1").valueAsString; 

if (v=="") event.value = ""; 

else { 

    var score = Number(v); 

    if (score<14) event.value = "Unsatisfactory"; 

    else if (score>=15 && score<=22) event.value = "Below Requirements"; 

    else if (score>=23 && <=29) event.value = "Meets Requirement"; 

    else if (score>=30 && <=35) event.value = "Exceeds Requirement";

    else if (score>=36 && <=40) event.value = "Outstanding"

} 

[try67]

The code is fine. Where did you put it and what were the results? Did you check the JS Console (Ctrl+J) for error messages?

[sl113]

I did "Actions", "Mouse up", and then "Run a JavaScript".

When I try to click "OK", the line "else if (score>=30 && <=35) event.value = "Exceeds Requirement"; shows an error.

[try67]

No, that code should be used as the custom calculation script of the field where you want to display the result.

[Thom Parker]

This code is intended for a calculation script, not a MouseUp script.

The code is missing a variable. Write the "if" like this

else if ((score>=30 && (score<=35)) event.value = "Exceeds Requirement";

this needs to be changed in several places.

[try67]

You're right, I missed that mistake. However, there's also a mistake in your code (the number of opening and closing brackets doesn't match). This is the correct version of the full thing:

var v = this.getField("Field 1").valueAsString; 
if (v=="") event.value = ""; 
else { 
    var score = Number(v); 
    if (score<14) event.value = "Unsatisfactory"; 
    else if (score>=15 && score<=22) event.value = "Below Requirements"; 
    else if (score>=23 && score<=29) event.value = "Meets Requirement"; 
    else if (score>=30 && score<=35) event.value = "Exceeds Requirement";
    else if (score>=36 && score<=40) event.value = "Outstanding"
} 

[sl113]

Thank you! That worked brilliantly!

[robertol86202666]

Anyone know how I could set a code to automatically generate a specific number range:

For instance, if I have one variable that can range from 1-43 and another variable that can range from I-VI (I'd prefer to leave it in roman numerals), how can I create a table that would automatically populate "1-6" in a field or "57-71" depending on the two variables?  Because there is no mathematic relation between the two variables and the output, I figure I will have to manually insert all the results (which I do not mind) so long as I can get the field to auto-populate.

Thanks in advance.

[try67]

Yes, you would need to do that. You can use something like this if-condition:

if (v1>=1 && v1<=43 && (v2=="I" || v2=="II" || v2=="III" || v2=="IV" || v2=="V" || v2=="VI")) ...

Edit: code fixed...

[try67]

You can probably also find a generic JS function online to convert Roman numerals to regular numbers, or write one yourself...

[sl113]

Thank you!! Now it works!

[SliceOrange]

Hi,

I have a similar question. I'm creating a form needed for bungalowparks, and I need a dropdown menu that shows the name of a park. I want the next text field to automatically state what the adress is of the park in the dropdown menu but I can't figure out how to do that. Can someone please explain?

Thanks in advance!

[try67]

Did you read this thread in full? The solutions provided here should be applicable to your situation as well.

[teresatownsend]

Could someone help me with this. I have a .pdf form (using Adobe Acrobat Pro DC) that I created that has 7 checkboxes. I found the correct javascript to have other fields in the form to show or hide based on if the checkbox is checked or not. This document has two pages. The first page is set up more like a form; the second page is going to be used to generate a letter to a client. I would like to create text boxes that populate (page 2 - letter) based on what is checked in the checkmarks.

I have a checkbox one that when it is checked, it brings up 4 text boxes and a dropdown boxes for users to enter text in the text boxes and to choose 1 option from the drop down box. If the user checks checkbox 1, checkbox 2 and checkbox 3 and its corresponding text boxes or drop down boxes do not show on the form. The first half of the form consists of three check boxes and only one should be chosen. The second part of the form has 4 checkboxes and other boxes that the person can choose from more than one. I have managed to get the information to populate from page 1 to page 2 based on which check marks are chosen, but there may be a lot of wasted space in between those options (page 2) since some of the information doesn't need to populate over.

What I would like to do is have page 2 look more like a letter and have only the information that is checked from page 1 to flow over to page 2 (use text boxes that bring over information from the text boxes and dropdown boxes based on the checkmarks that are chosen. It doesn't matter that the 1st page has empty spaces between what is chosen, but since the 2nd page should look more like a letter, it does matter. Its ok for the first page to have dropdown boxes and checkboxes but the 2nd page should just have text boxes that are populated based on the fields chosen from the first page.

This is my javascript for the checkboxes to determine what other boxes get chosen on page 1.

var nHide = event.target.isBoxChecked(0)?display.visible:display.hidden;

this.getField("DD1").display = nHide;

this.getField("Text1").display = nHide;

this.getField("Text3").display = nHide;

this.getField("Text4").display = nHide;

var nHide = event.target.isBoxChecked(0)?display.hidden:display.visable;

this.getField("CB2").display = nHide;

this.getField ("Text5").display = nHide;

this.getField

("OR1").display = nHide;

this.getField ("CB2").display = nHide;

this.getField ("Text6").display = nHide;

this.getField ("OR2").display = nHide;

this.getField ("CB3").display = nHide;

this.getField ("Text7").display = nHide;

this.getField ("Text8").display = nHide;

That is working correctly.

[caseyedwards3sons]

I am creating a form where I simply need one text field to equal the Negative of another text field. I am not sure how to make this happen. Help.

[charlesl57872296]

I have a form used for status updates (law firm) where I'm trying to have one drop-down menu for which office the file is coming from (easy enough and already done)...Once chosen I need it to auto-fill the phone number for that specific selected office into another field.  In yet another field  I need another drop-down with all the employees in that specific office to populate and will be visible to select who is filling out the form.

The first part is easy, the other two I'm sure I can figure out over time but it seems like many of you are extremely knowledgeable and can help me quite a bit faster then me banging my head against the wall.

To clarify as well...I realize all of this can be done thru excel and then converted but was hoping to do it all thru the Prepare Form tab in Acrobat.  Thank you!

[Thom Parker]

Post this question to a new thread

[tap517]

Hi! 

in my form, based on the location value chosen from the dropdown titled "location" I want it to generate a specific email address in the "coordinator" field (for purposes of having the "submit" button generate a specific email address to send the form to based on what location is seleced). I'm a total noob so any siplified help would be awesome!!  

so if "Spain" is selected as location, I'd want xxxxxxx@gmail.com to generate in the coordinator field 

If "Prague" selected, I'd want possibly a different email to generate