Load DB data when drop-down value is selected

[cornilm]

Hi,

First of all this is the best component ever!!! thx for that

Now, i am trying to create a job/planning component for joomla
so far i have a job form / product form / crew form.

when a job is created you can select one or more crew members and also products.

for the moment i have problems with the creation of the crew form i want to be able to link the entered crew member to a joomla member
So i have a form with the following:
1 field for the name
1 drop-down (database join) with registered joomla members
1 field for phone number
1 field for email
1 field for function
1 field for link to community builder profile

When the user selects a joomla member from drop-down i want the rest of the data to be loaded into the fields is this possible if so how?

 

[troester]

Have a look at the autofill form plugin
http://fabrikar.com/wiki/index.php/Form_plugin_autofill

Maybe you must update from GitHub to install it
http://fabrikar.com/forums/index.ph...s/#Installing_and_Enabling_Additional_Plugins

 

[cornilm]

yes i did but that is to load data form tables created with Fabrik.
My data is comming from: comprofiler & joomla user table

 

[troester]

You can create fabrik lists linking to any existing database table.
Make sure to set "Alter fields types"=NO (list "Advanced").

Or maybe with CascadingDropDrown elements you can achieve what you want.

 

[cornilm]

THX That did the job