Store Form data to database and retrieve in backend
-
- Power Poster
- Posts: 444
- Joined: Wed Jan 25, 2006 11:53 am
- Location: Netherlands
Store Form data to database and retrieve in backend
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
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
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.
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.
Not getting the answer you need? CMSMS support options
-
- Power Poster
- Posts: 444
- Joined: Wed Jan 25, 2006 11:53 am
- Location: Netherlands
Re: Store Form data to database and retrieve in backend
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.
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
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.
If you want to go the Excel route, both of the module suggestions have export to csv capability.
Not getting the answer you need? CMSMS support options
-
- Power Poster
- Posts: 444
- Joined: Wed Jan 25, 2006 11:53 am
- Location: Netherlands
Re: Store Form data to database and retrieve in backend
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.
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
Hi
you can click on the key-symbol in teh background of Formbrowser to get a list.
Regards,
Jan
you can click on the key-symbol in teh background of Formbrowser to get a list.
Regards,
Jan
-
- Power Poster
- Posts: 444
- Joined: Wed Jan 25, 2006 11:53 am
- Location: Netherlands
Re: Store Form data to database and retrieve in backend
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)
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
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
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
-
- Power Poster
- Posts: 444
- Joined: Wed Jan 25, 2006 11:53 am
- Location: Netherlands
Re: Store Form data to database and retrieve in backend
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.
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
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
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
-
- Power Poster
- Posts: 444
- Joined: Wed Jan 25, 2006 11:53 am
- Location: Netherlands
Re: Store Form data to database and retrieve in backend
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.
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.