Populate fields based on dropdown selection

Explorer ,
Dec 22, 2020

Copy link to clipboard

Copied

Hello Adobe community,

     I need help with the following task. I have an excel spreadsheet that consists of Room Status (consists only VAV and CAV). , Room Numbers (multiple rooms), Shop Name (multiple rooms) and Parent Loction (multiple rooms).  My senario is when Room_No is picked, I want all fields (VAV_CAV,Shop_Name &Parent_Location ) related to that Room_No populated. A room is either CAV or VAV has a shop name and parent location.

Field names:

Room Number (Room_No), Shop Name (Shop_Name) and Parent Loction (Parent_Location).

 

Shop.JPG

I appreciate your time and help.

Adosh.

TOPICS
PDF forms

Views

40

Likes

Translate

Translate

Report

Report
Reply
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
try67 LATEST
Most Valuable Participant ,
Dec 22, 2020

Copy link to clipboard

Copied

Assuming this is a PDF form, and you have Acrobat, you can achieve it using a custom-made script.

See this tutorial on how to do it:

https://acrobatusers.com/tutorials/change_another_field

 

If you're interested, I've created a (paid-for) tool that allows you to set it up very quickly and easily, without having to write any code. You can find it here:

http://try67.blogspot.com/2015/07/acrobat-populate-fields-from-dropdown.html

You can also get it from my new web-site, where's there's currently a "soft launch" sale (The discount code is available on the front-page):

https://www.try67.com/tool/acrobat-populate-fields-from-dropdown

 

Likes

Translate

Translate

Report

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