http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Wed, 08 Feb 2012 09:03:00 +0000 http://www.perfectforms.com/forums/topic/form-connection-error-on-update#post-1039 Tue, 22 Dec 2009 11:17:24 +0000 ijobling 1039@http://www.perfectforms.com/forums/ <p>System Error #1 does not necessarily mean it is 'permission'. In fact you should be presented with a message to indicate if this is the case.<br /> This could be a number of reasons. for instance trying to update a date/time field with TEXT.<br /> Go to the Connection | Action and run the 'test' there where you can enter in data that you are expecting to collect on the form (with the forminstance ID all the time of course so the instance can be found) step by step to isolate the specific field involved with this problem.<br /> If you are unable to track this down though, please export our your 2 forms and the connection &#38; action and send over to <a href="mailto:support@perfectforms.com">support@perfectforms.com</a> (with any relevant information on the data that will be initially entered on the form that is being updated) and we can check it out </p> http://www.perfectforms.com/forums/topic/form-connection-error-on-update#post-1038 Mon, 21 Dec 2009 19:48:56 +0000 pointreyes 1038@http://www.perfectforms.com/forums/ <p>Even more baffled now. Did more testing.</p> <p>#1 Create a new form with just two fields and created new form connections for doing updates to submitted forms - it worked!</p> <p>#2 With the new form added another field, hide it and mapped the published version and again tried the update connection with the hidden field - it worked!</p> <p>Used default permissions.</p> <p>The other form which has many more fields and in this case was a field added to already submitted forms and was mapped (hence the reason for test #2). There is no events on this field.</p> <p>Very confused on where to go from here. </p> http://www.perfectforms.com/forums/topic/form-connection-error-on-update#post-1037 Mon, 21 Dec 2009 19:09:57 +0000 pointreyes 1037@http://www.perfectforms.com/forums/ <p>I can use the READ functions in the form connections without an issue; however, I cannot seem to get the UPDATE function to work. I get the Form connection error System Error: #1 which would mean that there is a permissions issue. I don't quite understand what I'm doing wrong. Type is 'Update', Active is checked, Permissions - tried Use Allow and have now switched to Full Control Allow for Everyone. I provide the fields I want to update (not in a table and not a list or pull-down field). When testing I provided the Form Instance ID. I can search with this value to pull data from the instance I'm attempting to READ (Field Meta-Instance ID). </p> <p>Here's what I have tested:<br /> Form Instance ID left blank - ERROR: Form connection error The form-instance was not found.</p> <p>Form Instance ID not valid - ERROR: Form connection error The form-instance was not found.</p> <p>Enter a valid Form Instance ID: ERROR: Form connection error System Error: #1</p> <p>Enter a valid Form Instance ID and the Field I want to update with valid text input to a text field: ERROR: Form connection error System Error: #1</p> <p>What do I need to do? </p>