Can this be done with Chronoforms?

I would like to do the following and I would like to know if this can be done with Chronoforms.

I have an Joomla Estate Agent Component which I want to expand with an inventory list. So each object should have 1 unique list. What I basically want is to show a dropdown with object ID's and Names and when I select one of them the inventory for that object is shown. Which I then can fill and submit and get recorded in a separate table

So, in short the new form will be an inventory list which must have a 1-on-1 relation with an existing Joomla table.

Thanks,
KooTjoo

Hi KooTjoo,

That should be no problem - you can read the database table and create a drop-down from the results.

You can see the method in this article from The ChronoForms Book.

Bob

Hi,

Thanks for the response. Before I try to get this working does this mean that I can have a form with one dropdown box in it which gets filled automatically and then when I make a selection the rest of the form automatically gets filled in and can be changed?

I short that there is a relation of 2 (or more) tables in 1 form.

Thanks,
KooTjoo

Hi KooTjoo,

Oops sorry, I missed the second part of the question.

Yes you can do that too. Either with a two-step form, or using Ajax to populate the form once the selection has been made.

Which route to take depends a bit on how much data is in the inventory part. I'd probably use the two-step if there are more than a few entries to each inventory record.

Bob

Hi,

Great, thanks again for your quick response. There are definitely more than a few entries in the form. Is ther also a sort of manual on how to do this (the 2-step way)?

Do I also have to use ChronoConnectivity with this or can it all be done in Chronoforms?

Thanks again.

KooTjoo

Hi KooTjoo,

I think I'd create Form 1 with the drop down and have that redirect to the second form adding the id of the selected item onto the end of the URL.

You don't have to use ChronoConnectivity, it's just often convenient when you are dealing with lists of items from a DB table.

Bob