cbt
wading in the water
Posts:26
 |
| 07-23-2009 09:03 AM |
|
I'm in the process of evaluating your product and am stuck on one thing. I've created a form and I want the users to only submit the form once. However, this will be an annual process. I've created a user and submitted the form and it is now displaying the message that the user has all ready submitted the form. My question is, how do I "reset" the submission status. I've tried purging the results, but that did not do anything. I've also tried turning the "Only allow form submission once per user:" off and on, and that did not do it either.
Thanks for your help. Awesome product. |
|
|
|
|
David To
river guide
Posts:2719
|
| 07-23-2009 09:50 AM |
|
Hi, unchecking the "Only allow form submission once per user" should have taken care of the issue. What version of DNN / Dynamic Forms are you running? Also, do you have the "Display Message to User After Initial Save" also checked under Module Configuration / General Settings? -- David |
|
|
|
|
cbt
wading in the water
Posts:26
|
| 07-23-2009 09:54 AM |
|
Thanks David:
If I uncheck the "Only allow form submission once per user", I can then see the form again. But if I then re-check it (after I've purged results) I get the submitted message again.
Info you requested:
DNN 05.01.00 (773)
Dynamic Forms:3.0.10
And, yes "Display Message to User After Initial Save" is checked. |
|
|
|
|
cbt
wading in the water
Posts:26
|
| 07-23-2009 10:02 AM |
|
Here's one more weird thing... In FireFox I can see the form. Logged in as the same user in IE 7, I get the form all ready submitted message.
Craig |
|
|
|
|
David To
river guide
Posts:2719
|
| 07-24-2009 06:44 AM |
|
Interesting. I've switched on ""Only allow form submission once per user:" on and it works fine in both IE/Mozilla. I then switched it off and I can see the forms in both. In IE, can you clear all your temp history files/cookies, etc. and see if this fixes the problem? -- David |
|
|
|
|
cbt
wading in the water
Posts:26
|
| 07-24-2009 06:52 AM |
|
I did that, and unfortunately I got the same result. In your example, did you try turning "Only allow form submission once per user:" back on after you turned it off?
Here is my scenario:
1) User A logins and submits a form. Ok.
2) User A tries to browse to the form again and gets the message about one form submission. Ok.
3) A year passes by and the administrator wants to allow users to submit the form again (only once for the new year). The admin goes in purges results from previous year and turns off "Only allow form submission once per user:" and then turns it back on.
4) User A tried to complete the form for the new year... No luck User A still sees the single submission message.
Craig |
|
|
|
|
cbt
wading in the water
Posts:26
|
| 07-24-2009 07:05 AM |
|
Correction... After seeing that it was working in Google Chrome and FireFox I tried deleting temp files and cookies again. This time it worked... I got back into the form. I'll try submitting the form again...
Thanks for your patience and help.
Craig |
|
|
|
|
cbt
wading in the water
Posts:26
|
| 07-24-2009 07:30 AM |
|
It's definitely an IE cookie issue. After I submitted the form, I went looking for the cookie. It won't let me resubmit the form until I delete the cookie... When I look at the cookie data, I see _Module545_DynamicForms equal to true. If I remove that portion of the cookie I can then see the form again.
As a suggestion (and you can take it or leave it), it seems like it would be more reliable to store the fact that a form was submitted by a user in the database. With the cookie approach, if I log in as the same user using a different machine and/or browser, I can submit the form again. If it was based on data in the database, the module could actually check to see if the form was submitted by the user.
You can see the same result. With the submit once option turned on, login as user A using IE and submit a form. Browse back to the form and you should see the message about submitting once. Now, login as the same user using Firefox. You'll be able to submit the form again...
Craig |
|
|
|
|
cbt
wading in the water
Posts:26
|
| 07-24-2009 08:18 AM |
|
For anyone else who runs into this issue, I got around this issue by creating a custom validation stored procedure. Using tokens, I passed in the UserId and ModuleId. If the user has any responses, I respond IsValid = false... Here's an example my sp:
/*
======================================
*/
CREATE PROCEDURE [dbo].[DynamicForms_Validate_Submission]
@ModuleID as int,
@UserId as varchar(100)
AS
Declare @Valid int
Set @Valid = 0
Select @Valid = count(*)
From DynamicForms_QuestionResponse qr
inner join DynamicForms_Question q
on q.DynamicQuestionID = qr.DynamicQuestionID
Where q.ModuleId = @ModuleId
and qr.UserId = @UserId
Select case when @valid = 0 then 'true' else 'false' end as IsValid
/*
======================================
*/
|
|
|
|
|
David To
river guide
Posts:2719
|
| 07-24-2009 08:20 AM |
|
HI, thanks for the contribution. Exactly idea to use SQL validation for this scenario. -- David |
|
|
|
|