• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Dynamic Drop-downs

Dynamic Drop-downs 13 years 3 months ago #16321

What I wish to do is the following:

Use the sample script "Auto-populate a list from a table" to populate a dropdown box (eg. show all team names from a table in Joomla).
A second drop-down box must then be limited to only team members from the team selected in the first drop-down. This data will also be obtained from another table containing only team members and a link field to their respective team.

eg. tableteams
teamID, teamname
1 manchester united
2 liverpool
3 Chelsea
etc

eg. tableplayers
teamID, player
1 John Smith
1 Paul Lewis
3 Steve Norman
2 Allan Loyd
etc

If I select "manchester united" from the first drop-down then the second drop-down should only show "John Smith and Paul Lewis".

I'm sure this is possible - any helpers out there?
Cheers
Ben
The administrator has disabled public write access.

Re: Dynamic Drop-downs 13 years 2 months ago #16339

  • matt
  • matt's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 136
  • Thank you received: 14
Go to the demo page http://demo.rsjoomla.com/dynamic-drop-down-change-form-example and download the example and modify it.

Matt
The administrator has disabled public write access.

Re: Dynamic Drop-downs 13 years 2 months ago #16342

Hi Matt,
The page you refer to bases everything on hard coding - my requirements are dynamic.
Cheers
Ben
The administrator has disabled public write access.

Re: Dynamic Drop-downs 13 years 2 months ago #16378

  • penskyc
  • penskyc's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
I have the same issue - and am looking for a solution as well. Long story short - I have a script which pulls data from one of my joomla tables into a dropdown. Script works fine, however I cannot find out how to put the PHP call into the form. The call is
<SELECT NAME=thing>
<OPTION VALUE=0>Choose
<?=$options?>
</SELECT>

but when I enter in form layout the php code is stripped, and when I try entering it into the value section of RSForm it doesn't recognize it. This is the last piece of the puzzle, any help would be grand.

Thanks.
The administrator has disabled public write access.

Re: Dynamic Drop-downs 13 years 2 months ago #16472

  • siecool
  • siecool's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
In this exemple, I do not know or do we put the first code, I do not see "CSS and Javascript" tab derived, namely in the "Javascript" section
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!