Hi,
I have a field in my form that I have set to show: admin

The puropose of this field is so the admin can add comments to a form submission.

Here is how it should work:
1. User submits form
2. Admin edits submission, adding their comments to the field that is set to display to admins only

However when I do this, the data I enter into my admin-only field is not saved.

I also tried setting a default value in this admin-only field. When I submit the form as a "regular" user, this default value is not saved.

Note that this is *not* a hidden field type
- I am using the "Hide / show field from these roles:" function to hide this field from everyone but admins.

I am using:
 - DNN 05.02.00 - Community edition
 - Dynamic Forms 3.30.50

I can send you the module export XML file if you like.

Thanks,
Alen

Hi, herein lies the problem / issue with hiding by roles. When you hide a field by role (ie. Admin), that field only displays/renders when an Admin is signed on. If a user is filling out the form, that field doesn't render and on submit, does not get saved so later on, if an Admin were to try and edit that user's form submission, that field essentially doesn't exist.

Since this field is only for Admin use, you may consider switching it to a "Hidden Field" type which does get rendered. Then you would see it in the Form Submission result. -- David

Okay, this has been fixed. Here is Chad Nash comment:

1. By Design – If a field is set to ‘Show by role’ if the user doesn’t have that role then the field will never get rendered and therefore no default value will ever render for that field. This is working by design and I believe was the initial question (or at least my understanding of it).
2. By Design – If an Admin were to go back to the field that the user submitted and edit the results, that admin would then see that field and should be able to submit it. From what I have tested this is not working by design.

By looking into the issue, Chad Nash has discovered what the problem is. Here is the updated SQL stored procedure you can execute under Host / SQL to fix this issue:

alter PROCEDURE [dbo].[DynamicForms_UpdateDynamicResponse]
@DynamicQuestionResponseID uniqueidentifier,
@QuestionID as uniqueidentifier,
@Response as nvarchar(4000),
@UserID as integer,
@UniqueResponseID as uniqueidentifier


AS


Declare @MyCount int
Set @MyCount = (Select count(*) from DynamicForms_QuestionResponse Where UniqueResponseID = @UniqueResponseID AND DynamicQuestionID = @QuestionID)

IF @MyCount = 0
BEGIN
Insert Into dbo.[DynamicForms_QuestionResponse](DynamicQuestionID, Response, UserID, SortOrder, InActive, ResponseDateTime, UniqueResponseID)
Values(@QuestionID, @Response, @UserID, 0, 0, GetDate(), @UniqueResponseID)
END
ELSE
BEGIN
Update dbo.[DynamicForms_QuestionResponse]
SET Response = @Response,
UserID = @UserID
Where UniqueResponseID = @UniqueResponseID
AND DynamicQuestionID = @QuestionID
END

-- David