[richvle]

I have 2 dropdown controls on the same form.

{EDIT - I had the THEN portion reversed}
Approver1 and d Approver2. Both are dynamically populated with SQL.
If Approver1 has 0 records, then hide Approver1 and show Approver2.
If Approver 1 has > 0 records, then show Approver1 and hide Approver2.

Any ideas?

[programerboy]

Hi,
You can check this link and use onchange on your dropdowns:
https://wiki.processmaker.com/3.0/JavaScript_Functions_and_Methods#control.setOnchange

https://pmlearning.info
Thanks

[richvle]

Hi Programmerboy,
The OnChange is for when I made changes in selecting the options in Approver1. However, I'm not making changes in select the option. I'm referring to if the SQL query for it returns zero results.

Hi,
You can check this link and use onchange on your dropdowns:
https://wiki.processmaker.com/3.0/JavaScript_Functions_and_Methods#control.setOnchange

https://www.youtube.com/channel/UCYiyz1y8Qf4EZjMXodwH1iw/videos
https://www.linkedin.com/in/pmlearning/
Thanks

[streamsgeek]

Tailoring control options based on a dropdown selection mirrors the precision of the best basketball movies on Netflix. This feature optimizes user experiences, offering relevant choices akin to the excitement of basketball games. Like a well-executed play on the court, it ensures users can easily access and navigate through available options, enhancing usability and engagement in various applications and interfaces.
https://streamsgeek.com/7-best-basketball-movies-on-netflix/