Autopopulate form fields based on dropdown selection

Hi All,

I apologise if this has been answered, but the information i found has not specificly answered my question.

I am developing a intrenet CRM website.

We have 1 database / view via chronoconnectivity for Company Directory/Contacts.

We have 2nd database / view via chronoconnectivity for Company SALES LEADS.

I want the SALES LEADS database form (add / edit) to be able to have the choice of 1/selecting existing contact from the directory database on dropdown list which would then AUTOpopulate ALL the form fields with the contact info (need ajax or javascript?).

They can continue with all the sales leads information (i.e rating, amount, time schedule etc)

Thoughts would be appreciated

Hi ecopure,

There are a couple of documents on my site here which have some Ajax content though both of them cover slightly simpler applications.

In general I would not import all the data into another table but just include the id from the directory. This way you only have one set of data to keep up to date.

Bob

Hi Greyhead thanks for that prompt reply.

I thought you might say that, as i had something in the back of my head saying import the id only!
However is where the confusion starts:

from a users point of view, The directory needs to be completely seperate to the Sales leads system. However, the leads system needs to always add new potential contacts/ or update existing ones. Could i use just the one sql database and create two different chronoconnectivity / and forms so the user thinks it two seperate systems?

Hi ecopure,

I'm not sure exactly what you ae planning but I'm pretty certain that the answer is Yes. There is no problem in having several applications that use the same tables in different ways.

Bob

ok well once i have tried it, i will report and show a demo example🙂

how do i stop an empty field submiting '0' to the database?

Hi ecopure ,

Unset the value of that variable in the $_POST array (in CFv3) or the $form->data array (in CFv4).

Bob

Thanks for that.

So if I have two separate tables - and just store an id in the sales lead for the contact found in other database, how do I then show that as a user friendly name the contact when the form is reloaded to be edited or is viewed on the chronoconnectity?

HI ecopure,

Ideally you'd use a JOIN in the MySQL query but at the moment ChronoConnectivity doesn't allow that unless you use one of the hacked versions in the forums here.

Instead put this in the body section of your Listing - replace uid with the id column name.

<?php
$user = JFactory::getUser($MyRow->uid);
?>
. . .
Name: <?php echo $user->name; ?>

Bob