ChronoForms ChronoConnectivity 5 Example

The real benefit to Chronoforms is it is FREE.

I start with installing both ChronoForms and CronoConnectivity from Chronoengine. Go into Chronoforms and create a form. I started one here for customers. I wanted to keep their name, website, and password list. I started with a form called Customers.

After the designer elements of the form were finished  I did not go into set up yet. I went back to the “Forms Manager”, checked the “Customer” form and hit “Create table”. I ended up using the standard setting.

Now I go back into the form and add a couple of pieces to the “Setup” tab. In the “on load” section add “HTML (Render Form)” and “on submit” area add a “DB Save” from the Data Management elements.

You will now be saving the data to the database.

In ChronoConnectivity click “New” credential Manager. I am calling mine “customeredit”.  The Connection Name I called “customeredit”, and set published to “yes”.

Next click on “Models” and enter a new Model. I titled mine “customered” for customer edit. Use the dropdown to select the table where you stored the data from the form.

On the “Front List” tab Click on “Settings”. Select the display type as “Table”. The “Columns list” is the how the data is displayed when it is returned. The breakdown of the columns list is this:

customered.domain.DOMAIN = the model name . the database column name . the heading of the column ( you can make these up.)

The “Sortables” allows this column to be sortable once it is displayed.

On the “Actions” tab click “edit”. The form event will be the name of the form and the action. I called mine “CustomerEdit” and the action is “:load”. I don’t have this form created yet so we will do that next.

Before we leave this connection we need to set it permissions and that is to make the “view” allowed for the public so we can see it.

Go back to Chronoforms, check “Customer” our original form and hit the “Copy” button. Rename this copy “CustomerEdit”. This is what the the “Form event” is looking for.

Go into the form “CustomerEdit” and click on “Designer”

Click on the “Edit” button and set the “Field Name” and the “Field ID” for this “First Name” element to be “customered[firstname]”. This will tie the data coming over to this form together, so the firstname parameter will fill in the “firstname” field. Do the same with the rest of the elements. I also put a hidden field to collect the ID number.

Next go to the “Setup” tab. Add a “HTML (Render Form) element in the “On load” section. From the “External Apps” menu drag a “Connection Action”

Lastly add the name of the connection from ChronoConnectivity. I used the name “customeredit”. The Connection action is “save”.

You can create a menu item for the Form and the Connectivity View to see it all in action .

I will upload a zip file with the forms, connection, and database extract so you can use what I have working. It is easy to take my form and “Restore” it to your Chronoform and do the same thing with the Chrono Connection. The database table is easy to import a single table, and in my zip I have just the one table.

chronos_example_full

I am working on a Chronoform / Connectivitiy version 6 tutorial. Version 5 wasn’t easy to understand and version 6 is looking to be just as complicated. Version 6 does handle the database input better.

I hope this helps someone else out there…

 

Joomla Kickstart Restore – Blank White Page

Moved site from Localhost to Godaddy hosting and after I restored the site I got a completely blank screen in both the front end and backend. The source was completely blank.

I found this on OSTraining.com that let me see the errors by editing the “configuration.php” file in the CPanel. I changed “public $error_reporting = ‘development’;”.

https://www.ostraining.com/blog/joomla/white-screen-of-death/

I was now getting an error.

Error:
/home/myaccount/public_html/plugins/system/chronoengine_gcore2/chronoengine_gcore2.php on line 65

I recently upgraded the Chronoforms from version 5 to 6 while keeping 5 around. Their website said this was okay to do.

The site was working fine and this error seem to happen because of the restore. The restore was done through Akeeba Kickstart.

https://www.akeebabackup.com/support/akeeba-backup-3x/Ticket/27368-fatal-error-when-restoring-website.html

The end results was file permissions. My hosting account wouldn’t let me select a different PHP version. I had to contact tech support and they were surprised and had to go up to teir 3 to get it resolved. They determined it my CPanel account that was having permission issues to allow me to change the PHP version.

Once that was changed I was still unable to access the sites. I could put a HTML file there but couldn’t run any PHP. The folder permissions on the public folder needed to be reset to “750”. My sub-domain directories needed to be set to “755”. Godaddy said if I right-click on the folder I could change the permissions myself.

 

I hope this helps someone else out there….

 

ChronoForms – 1146 Table ‘XXXXXXXXX.#__chronoengine_forms6_blocks’ doesn’t exist

I moved a Joomla 3.8 site with Chronoforms 6 and I got this error:

 1146 Table 'XXXXXXXXX.#__chronoengine_forms6_blocks' doesn't exist

I quickly found this post.

https://www.chronoengine.com/forums/posts/t104239/1146-table-xxxxxxxxx-chronoengine-forms6-blocks-doesnt-exist

I backed up the form. Uninstalled the Chronoforms6 component and plugin. Downloaded the latest versions and restored the form. After that everything worked fine.

I hope this helps someone else out there…

 

Solved – Office 365 / Outook.com Not Receiving Emails From Website Form

Finished a site that is on Godaddy hosting, Domain is with Network Solution, and the Email is with Microsoft Office 365 Online.  The issue was the customer wasn’t receiving emails from the forms on the site.

The form would send to any email address except the clients email address. I contacted Microsoft and got wonderful help.

The fix was to use their “@theirdomain.onmicrosoft.com” email address and not the alias.

Microsoft told me it took them 3 days to determine this fix.

I really hope this helps someone else out there….

 

 

[Solved] – Chronoforms Dropdown Selected Item

Working a Joomla! 3.6.4 site and using Chronoforms V5 the customer wanted a dropdown item to start in the middle.

chronoform_dropdown_preselect

It was easier than I thought.  Here is what I had to do in the back end.

In the form designer I selected the dropdown element and added the Options item value I wanted to be the selected it, and added that in the “Selected Values”. The option I was looking for was the 100,000.

chronoform_dropdown_preselect_admin

I hope this helps someone else out there….

 

 

chronoforms multi-select Checkbox Group Last Item Only

I used Chronoforms to build a form that had checkboxes where a user could select more than one option; however, when it got submitted and I got the email only the last item showed.

I found this article, but I was still didn’t understand.

https://www.chronoengine.com/forums/posts/f2/t102571/i-cant-get-multiselect-to-work.html?hilit=use+checkboxes

Bob Janes was mentioning to the other user to use “[]” in the field group name. I didn’t find any “group name”, just the name of the field in the chronoforms element.  The first time I added it there it didn’t work but eventually it was working. So below is an image of what and where to add the “[]”.

chrono_multi_checkbox_1

I also used a “array handler” element from Chronoforms. It is in the basic setup section.

chrono_multi_checkbox_2

Make sure the “Array handler” is above the email container.

I hope this helps someone else out there.

 

Chronoforms V5 Auto Responder Set up

I was setting up an autoresponder in chronoforms and was getting the following error.
chronoforms_5_autoresponder

The first email to the site owner went and “your message was sent” displayed, but the autoresponder email element was causing the “Mailer Error”.

I had “email” in the Dynamic to field; however, the I got this error.

How I fixed it was by using a legitimate email address in the “from email” field in the first part of the email element in the setup tab of chronoforms.

I hope this helps someone else out there…

 

Chronoconnectivity V 5 for Joomla Tutorial

I love chronoforms and wondered about reading and displaying the data in such a powerful way. I looked at chronoconnectivity many times but quickly got discouraged.

I found simply going through their FAQ was a great start.

https://www.chronoengine.com/faqs/72-ccv5.html

Next I found the following walk through which were the next steps I was looking for and beyond.

http://www.icagenda.it/chronoforms-and-chronoconnectivity-tutorials-and-guides.html

I hope this helps someone else out there….

 

Solved – Chronoforms V5 won’t add database entry because of duplicate id – 1062 – Duplicate entry ’28’ for key ‘PRIMARY’

I had to hard code a URL and pass some parameters to a Chronoform in an article. The form submitted to a database. The form submission was taking the article ID as the form’s unique ID, so I could only submit once.

Bob Janes with Chronoforms totally fixed my issue with unsetting the varible with custom PHP.

https://www.chronoengine.com/faqs/70-cfv5/5234-my-form-data-isnt-saving-to-the-database-correctly-2.html

I hope this helps someone else out there…