Store Form data to database and retrieve in backend

Have a question or a suggestion about a 3rd party addon module or plugin?
Let us know here.
Post Reply
musicscore
Power Poster
Power Poster
Posts: 444
Joined: Wed Jan 25, 2006 11:53 am
Location: Netherlands

Store Form data to database and retrieve in backend

Post 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
User avatar
DIGI3
Dev Team Member
Dev Team Member
Posts: 1609
Joined: Wed Feb 25, 2009 4:25 am
Location: Victoria, BC

Re: Store Form data to database and retrieve in backend

Post 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.
Not getting the answer you need? CMSMS support options
musicscore
Power Poster
Power Poster
Posts: 444
Joined: Wed Jan 25, 2006 11:53 am
Location: Netherlands

Re: Store Form data to database and retrieve in backend

Post 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.
User avatar
DIGI3
Dev Team Member
Dev Team Member
Posts: 1609
Joined: Wed Feb 25, 2009 4:25 am
Location: Victoria, BC

Re: Store Form data to database and retrieve in backend

Post 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.
Not getting the answer you need? CMSMS support options
musicscore
Power Poster
Power Poster
Posts: 444
Joined: Wed Jan 25, 2006 11:53 am
Location: Netherlands

Re: Store Form data to database and retrieve in backend

Post 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.
janvl
Power Poster
Power Poster
Posts: 947
Joined: Wed Aug 13, 2008 10:57 am

Re: Store Form data to database and retrieve in backend

Post by janvl »

Hi

you can click on the key-symbol in teh background of Formbrowser to get a list.

Regards,
Jan
musicscore
Power Poster
Power Poster
Posts: 444
Joined: Wed Jan 25, 2006 11:53 am
Location: Netherlands

Re: Store Form data to database and retrieve in backend

Post 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)
janvl
Power Poster
Power Poster
Posts: 947
Joined: Wed Aug 13, 2008 10:57 am

Re: Store Form data to database and retrieve in backend

Post 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
musicscore
Power Poster
Power Poster
Posts: 444
Joined: Wed Jan 25, 2006 11:53 am
Location: Netherlands

Re: Store Form data to database and retrieve in backend

Post 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.
janvl
Power Poster
Power Poster
Posts: 947
Joined: Wed Aug 13, 2008 10:57 am

Re: Store Form data to database and retrieve in backend

Post 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
musicscore
Power Poster
Power Poster
Posts: 444
Joined: Wed Jan 25, 2006 11:53 am
Location: Netherlands

Re: Store Form data to database and retrieve in backend

Post 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.
Post Reply

Return to “Modules/Add-Ons”