I’m learning how to use the Glide App.
I have a quiz form that I want users to fill out. The quiz form is asking one question: “1 + 1 = ?” The quiz form has an answer field in the form of a choice component. The choice component is linked to an “Answer” tab in the spreadsheet that offers multiple choice answers for the question.
I want the student to be able to select an answer through the choice component. However, I only want the teacher to be able to update/change the list of answers themselves. Thus, I’ve assigned the teacher to be the row owners in the “Answer” tab.
When the teacher is the owner of the rows in the “Answer” tab, the student is unable to answer the question because they can’t see the possible answers. I’ve looked through the documentation and tutorials and the solution to my problem isn’t clear to me.
How do I get the answer field to appear for the student but still protect the master table for the teacher?
Thanks in advance.