+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: Two questions: confirmation and fix for error (/showthread.php?tid=1802)
Two questions: confirmation and fix for error - filch - Dec 7th, 2011
Hi Ben,
I have two questions I hope you can help me with:
1. Is there a way to show a confirmation message when a user is allowed to save and then return to update his or her submission. So, we have a Save button and this works fine with formtools and we have set "may_update_finalized_submissions" => true in the code at the top of the page. So, does the api provide a hook to show a confirmation?
2. I am getting unknown column error in Formtools. Anyway I can fix this?
Can send more info if needed. Just in a bit of a hurry at the moment.
Thanks Ben.
Dave
RE: Two questions: confirmation and fix for error - filch - Dec 7th, 2011
Just an update: the actual error is Unknown column 'col_56' in 'field list' Now, this column actual does exist in the database as well as in formtools. What looks to be the issue is that this error is generated when a user returns to update their submission. col_56 is actual the name field and this is already submitted with the original submission to set up the username and password. So, when a user is trying to update his/her submission and has logged back in, Formtools does not actually show the name text field ( col_56 ) in the page so it seems that the error happens because of this. The first field it encounters in the update routine is col_56 which is not part of the update process because it was submitted in the original insert into the database.
Hope this is not too obtuse..
Dave
So, in trying to track down the unknown column error, I see that when the ability to update submissions is in use, unless a user fills out their submission in total and then submits the form, the partially filled out form does not show up in formtools as an entry or submission. It does, however, show up in the database. This shouldn't be .... should it?
Dave