Problem with Checkbox-Arrays

Hello there,

I have a checkbox Group with these settings (screen).
In form it looks like this (screen1).
The checkbox options are also available in a table (edv_liste) in the database.
The number in the "Value" is identical to the "id" in the "edv_liste".

How can I display the selected checkbox values ​​in my one form and change now?
The form appears on CC. 5 Here I have a 1 connection created with 2 models.
Model 1 is working properly. Model 2 is for the 2. Tables and checkboxes.
Everything works so far, only the checkboxes values ​​there is a problem.
The debugger indicates that the array can be selected and sent (Screen2).

Thus, the array can be associated with a record, there is a second table "Foreign Key", "Primary key" and "user_id". The values ​​are stored right here, only the data from the "Foreign Key" are always "0", therefore, the checkbox values ​​are not in the form (screen3).

Perhaps also an error in the "Setup"( screen4)?
For the checkboxes I have extra "DB Read" and "DB Save", because the data are stored and located in another table and a "Handle Arrays" (screen4).

Maybe someone has an idea what to do.

Thanks in advance.
F.

Hi Fredolino,

I find it hard to understand the question :-(

I suspect that the Handle Arrays action is changing the values in 'edv' from an array to a string 1,6,11 and this may be the problem. You can check this by moving the DeBugger after the DB Save action so that you can see the query being created.

Bob

Hi,
I may have found the source of the problems with the storage of the arrays.
When someone submits the form in the frontend, then it is included in the Joomla registration.
With the Custom Code:

  <? php
$ form-> data ['user_id'] = $ form-> data ['_ _ PLUGINS'] ['joomla_registration'] ['id'];
?>

is stored in the table his user_id.
But now when I change to a form data and add more wishes (eg multi-selection checkboxes values) then overwrites my form the user_id in the table and puts my user_id a.
But I am also registered in Joomla as superuser.
What is the reason that the user ID is replaced?
Best regards
F.

Hi Fredolino,

I guess that you have some code or an action that is adding the current User ID to the form data. you need to set it up so that the saved value isn't over-written. I'm not sure where it is being added so can't say how to do that.

Bob