Simple database list form with add, edit and delete options - who can help me out....

hansk 12 Dec, 2021
I have recently activated chronoforms7 in joomla4 and I need a form to modify a simple joomla4 database.
Previously I created such forms using chronoconnectivity6 and they work well, but now I am stuck. And simply copying them to chronoforms7 is not possible...
Does anyone have tips or a simple example.
So a page to show the records of a Joomla database, with a button to add a new record to the database and for each record a button to change the record (on a new page) and a button to discard the record.
I can manage the first page with the record overview and the edit and delete buttons, but after that I get stuck...
Thanks in advance for the help and if possible a CF7 download file with a working example would be nice.

GreyHead 13 Dec, 2021
Hi hansk,

Have you checked the Basic Articles List Demo Form in CFv7. The description says "A list of articles in Joomla with View/Edit/Delete links, 2 filter fields (category and author) and one search field!"

Bob
hansk 13 Dec, 2021
Hi Bob,

Oups... I've seemd to miss that one.... I'll look into it to see if it solves my 'problems'...

Thanks a lot!!

Kind regards, Hans
hansk 14 Dec, 2021
Hi Bob,

i've been able to change this demo to connect to one of my tables and show the records with edit and delete options.
The edit option works but does not update the data in the database; the same for the delete action : no record is deleted....
It seems the right info is missing to tell what record to update/insert or delete but i'm unable to produce the right code....

I hope you can help out again!


Thanks in advance,

Hans
hansk 14 Dec, 2021
Hi Bob,

i've been able to change this demo to connect to one of my tables and show the records with edit and delete options.
The edit option works but does not update the data in the database; the same for the delete action : no record is deleted....
It seems the right info is missing to tell what record to update/insert or delete but i'm unable to produce the right code....
I've tried to add a where condition in the advanced settings but only able to delete a record if i use the id-value in digits, hard coded... :-) Not able tu find the proper syntax to code it properly.

I hope you can help out again!


Thanks in advance,

Hans
ieraora 15 Dec, 2021
For delete, do you like delete after select?

Simple database list form with add, edit and delete options - who can help me out.... image 1
hansk 16 Dec, 2021
@ieraora: Thanks for your help; i'll work on it!

Hans
You need to login to be able to post a reply.