Page 1 of 1
Store Form data to database and retrieve in backend
Posted: Tue Jun 29, 2021 1:30 pm
by musicscore
Hi CMSMS Lovers
I'm looking for a way to let frontend users add there name, e-mailaddress and phonenumber in a form and then that data is stored in the database so an admin can browse, retrieve that data in the backend.
This data wil be used as a contact list for mailing special events to users which descripted to that list.
I tried these modules :
formbuilder : I do not know how to store the data in the database and retrieve that data in the backend
NMS : Not recommend as this module is far to old
Lise : Do not know how to create frontend entry fields.
I searched the forum but most solutions are base and old modules.
Please your help / advice / tips.
TIA
Re: Store Form data to database and retrieve in backend
Posted: Tue Jun 29, 2021 2:15 pm
by DIGI3
FormBuilder has a companion module called FormBrowser which will do what you're wanting.
CGBetterForms (unsupported, but a fork called SmartForms is on the way) has a companion module called CGBFCrud (also to be forked soonish) which offers a full CRM method of storing/retrieving form data, but may be more than you need.
LISE doesn't have that functionality yet but it is in the roadmap.
Re: Store Form data to database and retrieve in backend
Posted: Wed Jun 30, 2021 4:39 pm
by musicscore
Thanks DIDI3 for your response.
Formbrowser is not the solution because I need the list of stored forms ONLY in the backend.
Futher Formbrowser does not yet support pretty urls and I need pretty urls for my Multi Language site.
I will test cgbetterforms and CGBFCrud but my first test gave an error wil selecting the CGBDCrud field.
Further I do not know if this two modules enable a admin to read the data in the backend.
I not so nice option would be sending e-mails with the forms to the admin so he can put the data in and excel sheet or database tool.
Not nice, be maybe the only solution so far.
Re: Store Form data to database and retrieve in backend
Posted: Wed Jun 30, 2021 5:05 pm
by DIGI3
Both FormBrowser and CFBFCrud have admin-only viewing options - I've never actually used them for front-end display. Pretty urls won't really be an option for the backend, regardless of the module. The backend only supports one language choice per user anyway.
If you want to go the Excel route, both of the module suggestions have export to csv capability.
Re: Store Form data to database and retrieve in backend
Posted: Wed Jun 30, 2021 5:09 pm
by musicscore
Thanks DIGI3
I tested FormBrowser because I think that is what I need only, could not find the backend list function.
So I will look / search again. Althou I use cmsms nw for 14 years, that's still a lot to learn.
Thanks again.
Re: Store Form data to database and retrieve in backend
Posted: Mon Jul 05, 2021 1:28 pm
by janvl
Hi
you can click on the key-symbol in teh background of Formbrowser to get a list.
Regards,
Jan
Re: Store Form data to database and retrieve in backend
Posted: Mon Jul 05, 2021 2:24 pm
by musicscore
Jan,
Thanks for the response. That is the solution.
Everything is working now as I would like it to work.
Thanks again.
Regards,
Paul (musicscore)
Re: Store Form data to database and retrieve in backend
Posted: Tue Jul 06, 2021 2:14 pm
by janvl
Hi,
glad to help.
Actually one can do a lot with the combination of Formbuilder and Formbrowser.
I made a simple ticketsystem with it, which does work but the user wanted more so i will save it for later.
I do hope that the dev-team will pick up this and have a look at formbrowser too,
Jomorg did a splendid job on Formbuilder, i hope one of the devs will do that with formbrowser too.
Regards,
Jan
Re: Store Form data to database and retrieve in backend
Posted: Thu Jul 08, 2021 5:10 pm
by musicscore
I got it working now accept for one field.
I created my own form and that is working perfect.
Accept the fieldtype "Email "From Address" Field" is not working.
The value is stored as an array.
I use the smarty tag {$email->input}.
There is an input field on the website but the e-mailadres is not stored. (or not visible in the frombrowser).
Please help.
Re: Store Form data to database and retrieve in backend
Posted: Sun Jul 11, 2021 12:02 pm
by janvl
Hi
i can confirm the problem with (fieldtype "Email "From Address" Field" ).
Try another fieldtype and we should probably file a bug.
I usually use the deprecated fieldtype so i have some testing to do before upgrading . . . .
Regards,
Jan
Re: Store Form data to database and retrieve in backend
Posted: Mon Jul 12, 2021 9:54 am
by musicscore
I'm now using the old field and that is working correct / perfect.
Sending in a bug report may be is not possible because formbrowser module is marked as stale.
It isn't even available anymore via the Manage modules option.
Formbrowser needs an update I think.