I will try to explain this as best as I can. I have a form that a public person can fill out for a complaint. When that complaint comes in, a staff member must review it and make any comments and refer it to another staff member. The way I have it set up is with 2 forms. One for the public, and one for staff comments/review.
When the first staff member reviews the submission, they are looking at the 2nd form (it includes the read only version of the first form). They can make comments and if they have more than one comment they must click "add another comments section" which duplicates the collection.
My problem is this: I do not want the next staff member to be able to change the previous staff members comments, date or time. I originally was thinking of making it read only but within a collection it seems to be difficult to tell forms to only make read only what is currently there but allow them to add a comment.
This form could loop 100 times if needed, so it's critical I have this functionality.
So I was going to have upon submit, a workflow retrieve the comment, date and time, and populate SQL with these values and then use this in another field called 'previous staff comments'.
The next staff member would open the routed form and the comments would either be greyed out or blank.
Ultimately if upon submit, I could lock down those comments for good I would do that. If anyone knows how to that would be awesome. I have tried the disable function which works but then my SQL data is blank - I don't think workflow sees anything upon submit since it's disabled.
I've looked at a couple answers but it didn't get me any closer.
Another option is to collect the info in SQL as mentioned, but in the process modeller when sending to the next staff member, send them a blank 2nd form (with the read only values from the public form still). From what I know, this cannot be done. I've looked at the answers regarding 'reset', but isn't exactly what I'm after.
Any help would be greatly appreciated. Attached is the section of form in question.