Second form wont show up

terokankaanpera 06 Jun, 2012
I've had one form on a Joomla 2.5 site since the begining. It stores submissions in the database and sends them via email. Now I'm trying to make an other form, much shorter and only storing the information submitted to the database. The problem is no matter what I do, the only place I can make it to show up is on the wizard while editing. The first form can be shown via Forms manager Frontend view, the editing wizards Test form button, via menu link, via module and in an article. (The last one is actually how it is published on the site.) But the second form on the site will not show up in any of the before mentioned ways. I get the sites layout with only bradcrumbs and the Chronoforms footer ("Powered By ChronoForms - ChronoEngine.com") and nothing in between. I can't create database table for the form either. I've updated Chronoforms a few minutes ago again to the latest version to make sure its up to date. I can't even think where to look for a solution. Ideas?
GreyHead 06 Jun, 2012
Hi terokankaanpera,

You probably need to drag a Show HTML action into the On Load event of your form. Please see the video 'A First Form' at http://youtube.com/greyheadnet

What happens when you use Create Table?

Bob
terokankaanpera 06 Jun, 2012
Thank you for your quick response! And it helped. I don't remember putting all those actions on the first form, but there they are.

I also got the table created, earlier it didn't create the table and failed silently. But for some reason one of the fields does not get saved to the database and I can't find a reason.
GreyHead 06 Jun, 2012
Hi terokankaanpera,

If you use the 'Easy' Form Wizard the Show HTML action (and many others) is added for you. If you use the Form Wizard you have to add them yourself. (I still forget fairly often.)

Did the missing field have a dash, space or some other special character in the name?

Bob
terokankaanpera 07 Jun, 2012
The missing field is a simple text box with name, label and id 'nimi' (which actually is Finnish for name).
GreyHead 07 Jun, 2012
Hi terokankaanpera ,

Hmm 'nimi' should be no problem. By all means email or PM me the site URL and a SuperAdmin login and I'll take a quick look.

Bob
GreyHead 07 Jun, 2012
Hi terokankaanpera,

I was able to create a table from your form with no problems.

Bob

PS I installed AceSQL to check the table, it's a free extension you can keep it or uninstall it.
terokankaanpera 07 Jun, 2012
Again, thank you for your input.

I also got the table created, earlier it didn't create the table and failed silently. But for some reason one of the fields does not get saved to the database and I can't find a reason.



So the table got created earlier but when testing it I noticed the field 'nimi' input does not get saved to the table. This is the problem I'm now trying to solve. There are now five test records on the table, none of which have the text entered in the 'nimi' field.
GreyHead 07 Jun, 2012
Hi terokankaanpera,

The input name is nimi but the column name is Nimi. They need to be exactly the same so one of them has to be changed.

Bob
terokankaanpera 07 Jun, 2012
Thank you! I must have changed the field id and name after creating the table. Now things are working.
This topic is locked and no more replies can be posted.