Forums

Hello everyone
I'm Italian and I write through google translator - sorry for not perfect English -

I have a problem with the dropdown: Do not save the data in the table created.
I also tried with a small test set in this way

Insert dropdown and set by default:
1 = on
2 = off
required = yes

in the form in frontend I click my choice but after pressing the submit button in table view into backend does not appear no data

where mistake
Thanks in advance

angy

Hello angykristal,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How do I save form data to a database table?
P.S: I'm just an automated service😉

hello calculus00
thank you for your kind attention and response

you ', I was rather evasive because I think I did a simple thing, Cmq in detail I composed a form with a dropbox and a submit button

after saving the form I created the table with the key on the menu 'at the top - I checked the table and the fields are created among which the dropdown

then they again entered the form to set the data storage by inserting dbsave and setting the newly created table

saving works well, because 'I know the table view data saved but not those reported in the dropdown

I set the dropdown in a very simple way by default because 'I wanted to see if doing the test I saved the data in the table

for which the dropdown is set in this way:

in general:
field_name = team
field_id = team
options =
0 = no
1 = yes
options = empty selects the team
label = name team

in validation
required = yes

dynamic data = no

save and close the form

after the startup form from frontend and I select from the dropdown the "no" which in theory should be saved in the table. I press submit and in fact the data is saved in the table

I go back to the administrative side and receive the records in the table using the link that appears to the side to form created

the entered value and that '"no" does not appear in the dropdown field team reported

maybe I have to add the code?
I thought the value was saved directly via the submit after you have set just saving the data in the db

I hope I was more 'clear and I apologize again my English google translator
thanks again

angy

Hi angy,

You are using these options

0 = no
1 = yes

This means that when the User selects 'No' then '0' will be submitted and when they select 'Yes' then '1' is submitted. If you want to submit Yes and No then use these options:

No=No
Yes=Yes

Bob

hi bob
thank you for attention

change in dropdown value :
On = On
Off = Off

Data listing
Created Date/Time ID
2014-09-04 13:56:29 5

but result in table is

id 5
uniq_id
user_id 232 ( change in this moment)
created 2014-09-04 13:56:29
modified
team
utente
button3

😟 no value in team and utente, I tried again more 'times from the beginning to recreate the form with the table but I can not see the values ​​of the dropdown previously saved
other solutions for my problem ?
Thanks in advance

angy

hello bob

code wizard designer :

<div class="gcore-line-tr gcore-form-row" id="ftr-team"><div class="gcore-line-td" id="ftd-team"><label for="team" class="gcore-label-left">team</label>
<div class="gcore-display-table gcore-input" id="fin-team"><select name="team" id="team" size="" class=" validate['required']" title="" style="" data-load-state="" data-tooltip="">
<option value="">seleziona il tuo team</option>
<option value="No">No</option>
<option value="Yes">Yes</option>
</select></div></div></div><div class="gcore-line-tr gcore-form-row" id="ftr-utente"><div class="gcore-line-td" id="ftd-utente"><label for="utente" class="gcore-label-left">Dropdown Label</label>
<div class="gcore-display-table gcore-input" id="fin-utente"><select name="utente" id="utente" size="" class=" validate['required']" title="" style="" data-load-state="" data-tooltip="">
<option value="">seleziona utente</option>
<option value="No">No</option>
<option value="Yes">Yes</option>
</select></div></div></div><div class="gcore-line-tr gcore-form-row" id="ftr-button3"><div class="gcore-line-td" id="ftd-button3"><div class="gcore-display-table gcore-input" id="fin-button3"><input name="button3" id="button3" type="submit" value="Submit" class="" style="" data-load-state="" /></div></div></div>

thanks

angy

solved

hi bob
due to my distraction

😀 solved


Record view
id 8
uniq_id
user_id 232
created 2014-09-04 14:32:10
modified
team No
utente No
button3
Submit

Joomla! 3.3.3 —
Vedi sito
1 1 Utente
1 1 Amministratore
0
Esci


resolved

Fixed for my simple mistake and maybe I did not understand the use of the array handle, in fact I had set in db save:
Save under Model ID = yes (not fuction) instead = no (ok)
Use the data available under the Model ID key in the data array

forgive me of my distraction and inability ', thanks

Hi

I Have the same problem with a dropdown mennu. It doesn't save the data in the db

Here is the debug result

Array
(
    [chronoform] => inizio_registrazione_pay
    [event] => submit
    [artista] => 
    [nome] => 
    [descrizionecantante] => 
    [descrizione] => 
    [descirizione] => 
    [didascalia] => 
    [dropdown] => blu
    [button13] => Inserisci
    [id] => 2
)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
    [13] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `aa_inizio_registrazione_pay` (`artista`, `nome`, `descrizionecantante`, `descrizione`, `descirizione`, `didascalia`, `user_id`, `uniq_id`, `created`) values ('', '', '', '', '', '', '0', '4ecdedfe724eb365961e41e4ffad8572a9c63e19', '2014-12-10 17:52:29');
                        )

                )

        )

)

Help me please

Does your table have a field with a name matching the dropdown field name ?

Regards,
Max

I'm having the following problem: homogação procedures, certification, communication.

each has a responsibility area. I want to do the following in cronoForms v5: When o user fill in all
the form, select one of the three subject and send, go to the e-mail of the responsible area.

when I send departamento @ gmail = certification, the e-mail who get the is email @ gmail and not the certification

somebody help me!

grateful: Fabio

Hi Fabio,

Please see this FAQ

Bob