update drop down list

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.

2 posts
First unread post

2 posts

update drop down list#793650

By ashkufaraz - Tue Jul 04, 2017 12:26 pm

- Tue Jul 04, 2017 12:26 pm #793650

Hi
I have a drop down with sql

Code: Select all

SELECT ID,TITLE FROM pmt_organization_type

how can update drop down list after load form.

it is possible reload drop down list with java script?

Re: update drop down list#793655

By amosbatto - Tue Jul 04, 2017 3:13 pm

- Tue Jul 04, 2017 3:13 pm #793655

You can update the dropdown's list of options with this JavaScript code:

Code: Select all

   var aOptions = getFieldById("myDropdown").executeQuery();
   getFieldById("myDropdown").mergeOptions(aOptions);

See:
viewtopic.php?f=47&t=710110
viewtopic.php?f=47&t=710111

These functions used to be on the wiki, but the developers forced me to remove them, so now I put them on the forum because so many people need them.