Underlying sheet permissions required with a form?
If I have my users filling out a form to add data to my sheet, they need edit access to the sheet, is that correct?
And if they have edit access to the sheet, they can just go into the sheet and add data, which they are doing, incorrectly, which is why I want them using the form.
Everything in this app is in a workspace. How do I manage permissions so that they can fill out the form and the data is entered on the sheet but they can't just go edit the sheet?
I thought about locking columns, but not sure if that will prevent data entry from the form? Also, my sheet has a "top half" where I do some calculations and a "bottom half" where the data is entered, so if I lock a column so they can't mess with my formulas, it will lock the area where I want their data entered. If that makes any sense at all!
The form is on a dashboard. The sheets and dashboard are in a workspace and I've granted people edit access to the workspace (because there are two sheets they need to add data to via two different forms).