Several users share a library consisting of books, chapters and pages. When a user walks down to a page I would like him to answer questions. I do not have a problem to show him questions, nor to “record” answers in a multi user environment. Where I do have a problem is to obtain his answer. A text input field at the lowest level does not let me reference the user profile anymore. Can you help ?
If you make a relation in your answer table to the user table, you should still be able to reference your user table fields through the relation. All you need is the owner/user email in the answer table. I think you need to set it up as a user-specific column for the relation to work during add time. Another trick I saw recently is to us a template column to get the user and then make a relation off of that << this is easier.
How are you recording user responses? If it were me, I’d create a form button at the page level that writes answers to a new “responses” sheet. If you include a user identifier (RowID or email) and the page (RowID or some other unique page identifier), then you can you can easily track which users are answering which questions for each page.
I talk a bit about this in my “challenges” video in my gamification series:
Gamify Glide Apps Reboot #3: Challenges and Admin Awards
