Forums

Mapping form to table

ttrump 22 Mar, 2014
I am a newbie but I am trying to create a job request form that will only allow certain users to place orders. The form needs to pass data to database and then send an email to the marketing director.

1. I created the table in Designer within Chronoforms but do not know to map the fields to a table. I see where to create the table but not sure how to set up fields with drop down select list.

2. Not sure how to do the form login validation and or set the email action.

ANY suggestions for examples someone could provide would be greatly appreciated!
Max_admin 22 Mar, 2014
Hi ttrump,

Just use a "db save" action to save the form data to your table and an "Email" action to send the email, the login should be handled by Joomla's login module

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
ttrump 22 Mar, 2014
Thank you. I am working in design view in Chronoforms but don't see where to insert an action?
Max_admin 22 Mar, 2014
Under the "Setup" view, but if you have a simple form then you can still save the data and setup the emails under the same tabs under the "setup".
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
ttrump 22 Mar, 2014
Under "set up" I have:

Enabled (set to YES)
Table name (shows the correct table name)
Save under Model ID (set to NO)
MultiSave (Set to NO)
Model ID (set to Data)

Any thoughts?
Max_admin 22 Mar, 2014
And when you submit the form now, the data is not saved to table ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
ttrump 22 Mar, 2014
I can't view the form to test... I don't have any options on any tabs to choose Show HTML action into the On Load event.

Only thing that shows up when I test the form is the form name.
Max_admin 25 Mar, 2014
Please send me login to your website to check the form if the problem still exists!

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.