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

Conditional format - new field based on a selection from a Drop-down menu in another field PDF Form

New Here ,
Aug 05, 2022 Aug 05, 2022

I am looking to create a PDF form from an existing Excel workbook. 

The form contains several drop-down fields, with Responses "Yes", "No" or "Yes, please specify", "N/A"

I am looking to set up the form so that if a user selects the "Yes" or "Yes, please specify" option in some of the drop downs, to have a number of other fields come up. (If the users choses "No" or "N/A" I want no other options to be present).

For example, below I have a drop down menu in Cell H10 with options "Yes, Please specify" and "N/A".

When "Yes, please specify" is selected:

- cell I10 and J&K10 appear. I10 is populated with "Please specify" and J&K10 is blank for the user to fill.

- cells B-G11 (merged) appear and is populated with "If this is needed select response.?"; cell H11 appears with a drop down menu with options "Yes", "No"

miroslavaa37659137_0-1659704263615.pngexpand image

If "N/A" is selected in cell H10 - Cell I10, J&K10, B-G11 and H11 do not appear

miroslavaa37659137_1-1659704979775.pngexpand image

 

 

TOPICS
PDF forms
790
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 ,
Aug 05, 2022 Aug 05, 2022

You can use a script to show or hide fields, but they have to exist in advance, and when they are hidden there will just be an empty spot on the page where they are located.

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 ,
Aug 15, 2022 Aug 15, 2022

Do you know what script I can use?

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 ,
Aug 15, 2022 Aug 15, 2022
LATEST
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