Forums

Reply to and Store in database Questions

megajuz3003 22 Jun, 2007
hey all just have a few questions, i am using chronoforms 1.5 and i need to set the form so that when you recive the results in the form you can just hit reply and email the person that sent the form

also i need the results to be stored in a database aswell as email

any help would greatly be appreciated
GreyHead 22 Jun, 2007
Hi,

In a hurry right now. It's probably worth upgrading to v2.0 (or 2.1 released yesterday but I haven't used it yet).

You can save the data easily, just use the create table button in admin. And I think you can set the reply-to address in the email to use the value from the 'email' field - that should do the trick.

Bob
megajuz3003 22 Jun, 2007
hey dude its not working😟 i upgraded to 2.1 and it has me completley baffeled i might go back to 1.5 for now untill i can get it to work on a test site
GreyHead 22 Jun, 2007
Hi,

I'm sorry that it's not working for you - I put 2.1 on my test site and got a form up and running and saved some data. Tell us a bit more about what the problems seem to be.

Bob<br><br>Post edited by: GreyHead, at: 2007/06/22 13:31
megajuz3003 22 Jun, 2007
2.1 wouldnt let me send email from the form

i have put back 1.5 so i can go out and show my customer a sample tommorow but i just need to know how to get it to save to a database and how to set up a database initally
megajuz3003 22 Jun, 2007
hey dude i got everything working except the database any help would be appreciated soo much😀
Max_admin 22 Jun, 2007
Hi,

In order to get a form to email you must have those fileds :

#1- form name
#2- Email addresses
#3- subject
#4- fromname : e.g.: Admin
#5- fromemail: e.g.: [email]admin@admin.com[/email]

for dynamically changing the fromname and fromemail :
#1- fromname field : e.g.: fname -> this is your html field name
#2- fromemail field : e.g.: email -> this is your html field name

Cheers

Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
megajuz3003 22 Jun, 2007
i have that bit sorted and running beatifuly just need the data to also save in a database thats the confusing part
Max_admin 22 Jun, 2007
check the form name, click create table at the top right
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
megajuz3003 22 Jun, 2007
ok i have done that but it said i have already created a table humm must be coz i have done it all before and screwed it up i will make a new form and start from scratch
Max_admin 22 Jun, 2007
good idea, editing created table isn't an option yet!!

Cheers

Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
megajuz3003 22 Jun, 2007
ok i have everything working sweet as thanx for your help everyone
GreyHead 23 Jun, 2007
Hi,

In the ChronoForms forms manager select the form and click 'create table' the icon at the right hand end of the row. Select the elements and the data types. That's it really.

Bob
Max_admin 23 Jun, 2007
Thank you!! if you like this component then could you please put a review at the extensions directory of joomla? this helps us shows fair ratings as competitors do the same way!

Thanks

Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
megajuz3003 23 Jun, 2007
i most certinly will, the way everything is working i am absoloutly wraped in this software😀:D:D

is it possible to output the data to a external SQL database? that way i can pull the data the way i want to, just so everything looks very professional for my customer??
GreyHead 24 Jun, 2007
Hi,

You can access the MySQL data in the Joomla database - or you could copy or replicate it into another database if you need to.

What kind of things do you want to do to pull it into shape?

Bob
megajuz3003 24 Jun, 2007
ok umm how do i access that from something like Ms Access, because i want to pull the data so i can view all form submissions ummm like in a spreadsheet sort of view
GreyHead 24 Jun, 2007
Hi MegaJuz,

There is a basic 'data viewer' inside ChronoForms. You could copy and modify the code for this to give you a table view.

The free PHPMyAdmin or the MySQL Query Browser tools let you interrogate a MySQL database and display the results as tables. These are a good way to create useful layouts that you can then recreate on web page for your clients to view.

You can also export data to Access, or a spreadsheet - but you need to think this through as you may have problems keeping the displayed data in sync with the current Joomla/MySQL data from the forms. I think I'd choose to keep my core data in the Joomla database and create a little set of viewer pages to loook at it.

Bob
megajuz3003 24 Jun, 2007
hey dude thanx for that umm i have found the database and all that umm is there a way i can use a .php file in the joomla site to display the database?

if so does anyone have the code i need?

btw 36hrs straight if joomla work kinda makes u go insane LMAO
GreyHead 24 Jun, 2007
Hi MegaJuz,

Yes, you can create a page in Joomla to display the content but I think you'd need to build it from scratch. Code from the User Manager or from the Table admin in ChronoForms will give you a start. How easy it is depends on how much you know about Joomla. MySQL and PHP.

If you want some quick help in hacking some PHP code then there is a free PHP Code Generator available from SQL Maestro - but this would need re-tweaking to work in Joomla.

Bob
This topic is locked and no more replies can be posted.