app to collect user feedback

AppSheet AppSheet Q&A
1

Hello, I’m attempting to create a prototype for an app to be used during a conference.I want to collect participant feedback for each session.

It’s build from 5 Google sheets—a sheet for each session and a “Session” sheet to reference data from the others.
Each session sheet has identical headers that include "SurveyQuestion_1, “SurveyQuestion_2”, “SurveyQuestion_3”. The last three headers are the values from the survey headers.
I want to add a form that collects feedback from each session and writes it back to the corresponding session sheet (or to another sheet).
Ideally, the detail view in “Session” would have a button to go to a form template. where the input names come from the referenced session. Submitting the form would write the values back to a google sheet.

I need help getting the form to work. I’m not sure if I’ve set the data correctly.
If there’s a better way to approach this, please let me know.
Here’s a link the the app

THANK YOU VERY MUCH!!

2

Hello, i tryed to access to your app, but access is denied.

I don’t understant why you have so much sheets. I imagine one sheet “Question” with three fields, session number, question number, and question. And the second “Response”, with for example, session number and question number (the link to first sheet), response, user, date