Forums

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

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

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

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

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

hey dude i got everything working except the database any help would be appreciated soo much😀

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

i have that bit sorted and running beatifuly just need the data to also save in a database thats the confusing part

check the form name, click create table at the top right

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

good idea, editing created table isn't an option yet!!

Cheers

Max

ok i have everything working sweet as thanx for your help everyone

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

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

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??

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

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

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

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

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