Forums

I have created a form in CF5. I have used CF5 to create the table (turned off dynamic data to create the table, then turned it back on). The form has text fields and drop down fields. Some of the drop down fields are Dynamic Data, some are static. When I issue the submit the debug show all the fields in the array with the values I expect, but the fields that are setup as dynamic data do not get written to the table. Any thoughts.

Array
(
    [option] => com_chronoforms5
    [chronoform] => PlayerInfo-Create
    [event] => submit
    [DOB] => 02/04/1971
    [Number] => 
    [Position] => 1
    [Feet] => 
    [Inches] => 
    [Reach] => 
    [Weight] => 
    [GradYear] => 2
    [Grade] => 5
    [HighSchool] => C-A
    [HSAdd] => 
    [TShirtSize] => 1
    [UniTop] => 7
    [UniBottom] => 10
    [button18] => Submit
    [id] => 8
)


Array
(
    [6] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `LO_PlayerInfo` (`DOB`, `Number`, `Feet`, `Inches`, `Reach`, `Weight`, `HighSchool`, `HSAdd`, `user_id`, `uniq_id`, `created`) values ('02/04/1971', '', '', '', '', '', 'C-A', '', '0', '336432a93df6d59b5a7758f9edc20bfd52cea943', '2017-03-11 00:44:48');
                        )

                )

        )

)

Hello vividal,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
My form data isn't saving to the database correctly
My CFv5 form data isn't saving to the database correctly
P.S: I'm just an automated service😉

Hi vividal,

From the second FAQ that Prof Calc linked to: "If you have added or renamed any columns in the database table, please click the 'Clear cache' icon in the Forms Manager toolbar to update CF's records"

Bob

Thx, I click clear cache all the time and completely blanked on it when it wasnt working. All set.