Another gotcha:
- Just tested, and actually you need both read-write access to the table you want write to. Simply write access won’t be enough.
- Also the referenced table must be a table (
grid-xxxxxxxxxx), not a view.
So the only way to make a submission form where a user won’t be able to also read all the submissions is to either filter out all rows on the master table, or hide all the columns. Then use views in the source doc to review all the data.
Form demo:
Answers doc: