If/Then statement with drop down list

Question

Hello,

I have a table with 5 columns. Column 2 has a drop down list with options "Each", "Feet", and "N/A". I would like how to get column 5 to auto populate depending on the selection from the drop down.

1. If Column 2 = Each, then Column 5 = Column 4*Column 1

2. Else, Column 5 = Column 4

I have found similar posts and tried both a custom calculation and validation script but it does not work.

Please help.

Nesa Nurani · Accepted Answer

Thank you for responding.There are multiple rows. I want the form field in row 1 column 5 to autopopulate based on the other fields in row 1.Does that help?You can use something like this in each row of column5 "custom calculation script":if(this.getField("dropdown").value == "Each"){event.value = this.getField("Col1Row1").value * this.getField("Col4Row1").value;}Rename fields for each row, It's basic code but it should get you there with little adaptation.If you have any question feel free to ask.

Saul5C65 · Answer

Sorry, this is on Adobe Acrobat Pro DC creating a form

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