editable tables how to?

I am an experienced Joomla user but only recently started with Chronoforms 5 and Connectivity 5. I started with the 5 versions because there was more documentation to be found on internet then about version 6.

My case:
- I made a form and I can submit the data to the table in the database that I created
- I can show the data from the db table in a table in a Joomla article, so far so good

My problem is that I am not able to make the data from the article table editable in the frontend. I looked around on the forum and found some faq's but I just do not get it working. Is there some manual I can use or a video that I can watch? Any other tips?

Really looking forward for the helping answer.

regards,

Job

Hi Job,

Please see this FAQ

What exactly is not working?

Bob

Hello Bob,

thanks for the reply. I'll check the faq you sent and get back to you asap.

regards, Job

Ok, I managed to make the form editable and saveable with the use of the faqs. The only thing is that the edited record is being saved as a new record. Dit I miss something?

Hi Job,

You need to make sure that the id (or cf_id) of the record that you are editing is included in the form data. Usually it is enough to add a Hidden input to your Edit form with the name and value matching the Primary Key column of the record. You may need to rename the value after the form submits with a Custom Code action e.g.

<?php
$form->data['cf_id'] = $form->data['gcb'];
?>

Bob

Hello Bob,

works like a charm, thanks. Getting the hang of it I hope...! 😀