Forums

Hello,

I have created an entry form with a double dropdown using dynamic lookups in a table. This works fine.

I wanted to create a CC5 report and an edit form so that users could update the information previously entered into a table. I placed the edit form into the edit Action of the CC5 report. I put a Selector and an Edit link on the report, and this seems to work - I can select the record, click Edit and the form is loaded. However it doesn't display the data from the selected record.

I used the model name from the CC5 report, for all fieldnames (model[cf_id]), but just cf_id for the field ID. I then tried making the field ID to model[cf_id] but nothing happens.

Must be something fundamental I need to do but I can't see it.

Cheers

Tim

Hi,
I am having the same problem but I didn't find out any solutions.

Kiwiup

Hi,

First step is to use a "Debugger" action in the "on load" event of the edit form to find if the record data is correctly loaded.

Regards,
Max

Hi Max,
thank you for your speed answer.
I put hte debugger before html render form and this is the message can I get when click over edit form in Chronoconnectivity. Connection name is viewexdrop and model id is listexdrop.
I created two forms:
1. entry form (following a FAQ) with three dropdowns. It works.
2. edit form in CF5 same as entry form but with the name changed like listexdrop[dropdown1]. But in this case the conditions in the DB Read event ajax dosen't work because I modified the ocde in this way

<?php
  return array( 'id_reg' => $form->data['listexdrop['dropdown1']]);
?> 

and nothing happen in the second dropdown2 connected with.

Array
(
    [cont] => lists
    [ccname] => viewexdrop
    [act] => edit
    [gcb] => 146
    [listexdrop] => Array
        (
            [id] => 146
            [uniq_id] => 42ea60e46c6720e1664b3d4d526a24322b438b66
            [user_id] => 0
            [created] => 2015-02-13 11:33:00
            [modified] => 
            [dropdown1] => 2
            [dropdown2] => 6
            [dropdown5] => 351
        )

)

Thank you again.

Best regards

Kiwiup

Hi kiwiup,

I think that should be

<?php
  return array( 'id_reg' => $form->data['listexdrop']['dropdown1']);
?> 

Note the changed []s and extra '

Bob

Hi Bob,
I mae a change by following your suggestion but it didn't work.
I made a three dropdown dynamic chained following the FAQ example.
This entry form is called exampledrop. But after insering values I would like to modify one of them values because for example I made a wrong selection in entry data.
How can I arrange this situation?
I made a Chronoconnectivity form called viewdrop to show records from the tabel who contains a values inserted with exampledrop form.
Can I use the exampledrop form and how can I modify a DB read e Custom Code to load a right field name?
In the FAQ example there was written

<?php
return array( 'id_reg' => $form->data['dropdown1'] );
?>

but if I connect this form with a CC5 I have to modify a filed neme in the exampledrop like listexdrop[dropdown1] to load a data from DB but in this case didn't work a mechanism to chain dropdwon.
Best regards.

Kiwiup

Hi Kiwiup,

Do you have a link to the form so I can test it ? I mean the edit form, please send me link and login details using the "Contact us" page.

Regards,
Max

Hi ,
I will send to you as soon a link to the form so you can see directly what do I mean.
Thanks a lot.

Kiwiup.

Hi Max,
here is a link to my form
http://www.fabiocenci.it/badanticolf/administrator
I have created a account for you:
username: **********
password: ***************

There are two menu voices:
New record that calls a form Chronoforms exampledrop. This form works with problem.
View record that calls a connection name viewexdrop Chronoconnectivity to view a record inserted with exampledrop form but if you click over modifica and make a changing in some value the form doesn't save a changing just made.
Thanks in advance..

Kiwiup

Hi Max,
maybe I found a solution. I have a problem with the update of last dropdown.
Later I will send to you some results.
Best regards

Kiwiup

Ok, but please close the account you have created for me, because you had the login details on the public forum and who knows what could be done by this data!

Regards,
Max

Hi Max,
I deleted "your" account.
I have also a problem to show the exact value in edit form (CC5) in the second dropdown element. At the moment is shown a first list's value not the value extracted by DB.
Do you any suggestions about this?

Thank in advance.

Best regards.

Kiwiup

What's the link to your connection please ? I will check this!

Regards,
Max

Hi Max.
what do you mean with connection?

Thanks.

Kiwiup

Sorry, I mean the edit form, you can send me the URL and any required login info using the PM or the "Contact us" page!

Regards,
Max

Hi Max,
this is the url of edit form.http://www.fabiocenci.it/badanticolf/view-record.html.
If you select a record by clicking modifica the form shows a record.
The first value dropdown1 is correct but the second and third dropdowns have wrong values
Thanks.

Hi kiwiup,

Did you manage to get this working as discussed in another topic ?

As posted, you will need a db read to load the 2nd dropdown's values when the form is loaded.

Regards,
Max

Hi Max,
I have two tasks to get:
1. load in the 2'dropdown a value fron DB: this is ok with a DB Read and Dynamic Data in the dropdown element by inserting a model ID from DB Read and value e text key;
2. but I lost a mechanism to chian this 2 dropdown with the 1 dropdown. I don't know how to write a right code like in the entry formas explained in the FAQ (dropdown dynamically chained).
If I got these results I would like to share with a complete document .
Thanks a lot in advance.

#1- this is done using PHP BEFORE the page is fully loaded.

#2- this happens when dropdown#1 changes, so they can work together just fine.

What happens when you change the first dropdown at the moment ? assuming #1 works fine.

Also please keep the details on the other topic since its more dedicated to this question.

Regards,
Max

Hi Max,
when I open the edit form all the right value are loaded. In the first dropdown is loaded for example and item with id = 9. In the entry form if you choose an item with id = 9 in the second dropdown appears only 4 values connected with id = 9.
In the edit form in the secondo drodown there are all values not filtered by the choice made in the first dropdown so you loose the chain dropdown eachother like entry form based on FAQ code.

Thanks

Kiwiup

Hi Kiwiup,

Sorry, I forgot to answer here earlier.

I understand the problem you have, it should be fixed using the "Dynamic data" section as explained, you can even have this as 1 form only, for both new and edit features.

If you can't get it to work then you can send me a message using the "contact us" page so that I can login to your website and check your dropdowns setup.

Regards,
Max