Forums

Ok easy question, I have read what there is about Chronoconnectivity but I am still confused as to whether it is what I really want. I just need something to edit records in a chronoforms database. Chronoforms apparently just allows deletes; we are using it for a registration form for our church and at times need to edit a record. Am I missing the documentation somewhere?

Thanks for helping a newbie out.

Hi johkar1,

ChronoConnectivity is intended to let you display a list of results from a database table; and to search, filter, sort, edit, add and delete records from the table. But it uses ChronoForms for the edit and add forms.

ChronoForms, as you've seen, includes a very basic lister which is really only intended to let you view the data you have saved.

If you know the record that you want to edit then you can pre-load the data into a ChronoForm and use that to edit and save the info. Usually however you need the search, sort and filter features to find the record you want to edit.

Hope this helps.

Bob

I'm sorry, it still isn't clicking. I am trying to follow this tutorial (http://www.chronoengine.com/tutorials/other-tutorials/18-tutorials/40-chronoconnectivity-tutorial-1.html) but it is rather confusing. I don't care about the front-end...do I have to create it? Do I have to list every field I want to edit or just enough fields to know which one I want to edit? Also, I am not understanding once I am able to create the edit table where it will be available in the backend for me to access it.

Right now I can't even get the edit table created, I get this error. Woe is me and my understanding of this plugin.

TableChronoConnectivity::store failed - Unknown column 'OnSaveJSCode' in 'field list' SQL=INSERT INTO `jos_chronoconnectivity` ( `id`,`name`,`tablenames`,`SQL`,`head`,`body`,`footer`,`OnSaveJSCode`,`paramsall`,`Config` ) VALUES ( '0','SSReg','jos_chronoforms_SundaySchoolReg','','','','','if(0){ \r\n } else {\r\n submitform( pressbutton );\r\n }','ordersql=\nfrontfilters=\nposted=\ngeted=\nheading=\nenmambots=No\nlistlimit=25\ndeletelink=Delete Record\neditlink=Edit Record\nnewlink=New Record\nfront_edit_form=\neditform=SundaySchoolReg\nprimarykey=cf_id\nauthedit_groups=\nauthdelete_groups=\nauthnew_groups=\nauthedit_users=\nauthdelete_users=\nauthnew_users=','dataviewtitles=LastName, Mother\'s First,Mother\'s Last, Father\'s First, Father\'s Last\ndataview=LastName,MothersFirstName,MothersLastName,FathersFirstName,FathersLastName' )

Hi johkar1,

Just enough fields to identify the record, perhaps just the title.

There is a bug in one of the CC releases that gives the error you see. If you search here on OnSaveJSCode you'll find a fix, and an amended file I think.

Bob

Ok, I got the form data to work, that was pretty easy. I cannot save the edits though because of two JavaScript errors:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 3.1; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
Timestamp: Thu, 6 Aug 2009 02:47:56 UTC


Message: 'message' is undefined
Line: 158
Char: 5
Code: 0
URI: [DOMAIN TAKEN OUT]/administrator/components/com_chronoconnectivity/js/jsvalidation2.js


Message: Object doesn't support this property or method
Line: 59
Char: 102
Code: 0
URI: [DOMAIN TAKEN OUT]/media/system/js/mootools.js