Forums

An one post more: here is the way I did it. For experts of course not a big thing, but maybe there's a newbie who finds help with this.

As I posted a few days ago I did this with Chronoforms V5, Chronoconnectivity V5 and the plugins of forms and connectivity.
First of all I created the form, my form is only used for editing data.
In the designer I used a hidden label with field name and field id "cf_id" and field value "1" (thats important for editing the right row). Then I used the Radioboxes with the names court1, court 2 and court3 and the options "0=nichtbespielbar" and "1=bespielbar". The last thing I used was of course a submitbutton.

This was only the design of the form, before I went to the setup, I had to create a table for the. So we create a table at the forms manager. I only needed the fields "cf_id", "court1", "court2" and "court3". So I unchecked all the other fields.

Now I was able to do the setup for my form. First of all I used a "DB Read" to look out the current data of the table. It's important, that the DB Read is before the HTML Render form. Now go to edit DB Read, enable it and take the right table.
The second field is the HTLM Render form, but here I didn't edit anything. This two fields are in the On load.
The last field is the DB save, which you have to put in the On submit. There I had the biggest problems with the code in the update-conditions field. I used this code:

<?php
return array("cf_id" => $form->data["cf_id"]);
?>

Now my work at the form was finished and I had to bring the data in the frontend of my website.
So I changed to Chronoconnectivity and created a new connection.
At register "General" I only set the connection name and published: yes.
At models you have to give your model a title, this title you will need in the front list settings. At table name I selected the table I created at chronoforms. At "Fields" and "Order" I wrote all the fields of the table (cf_id, Verein, court1, court2, court3).
The last thing I had to do was the front list settings.There I selected Display type: table.
At columns list I wrote the fields I wanted to show. There it's important to write the modeltitle before the fields as you can see at the hint under the field.
At "binary" I wrote all fields, which should be able to change by my form.
The work in the connectivity was finished now and I only had to show the connectivity in the frontend. But this was easy. I installed the connectivity plugin and wrote this code in a costum module

{chronoconnectivity5}nameofthemodel{/chronoconnectivity5}

.

Walter