Form submissions
Is it possible to see original form submissions? It creates a row, sure, but can you prove who sent it in and what info they provided? ie., what's to stop someone from changing the info sent in and claiming it as original? Specific case we are having employees "sign" (check a box) a form but would like to be able to see the original if the validity of the submission were ever called into question
Answers
-
You could require that users are signed in and use a system generated Created By column to track who submitted the form.
To prevent the editing of data you could lock rows as soon as they are submitted using the Row Lock Automation. You could restrict sheet access through adjusting permissions. Form users do not need access to the sheet to be able to submit a form. You can use the system generated Modified By and Date columns to track who last updated that particular row. Change Highlighting can show what was changed and cell history/activity log will show the original data, what it was changed to, by whom it was changed and when.
