Capture data from a questionnaire in Google Forms for AppSheet

[Mar02]

Hi, I am creating an application in Appsheet that allows me to send documents certifying that a student passed an evaluation that is in Google Forms. When I connect my form as a data source in the Appsheet application, it brings me all the data that the student filled out; but since it is an evaluation questionnaire, the answer that the student gives generates a score which is not captured in the data source of my Appsheet application. Please tell me how I can capture the score of a questionnaire from a Google Forms and have it reach my Appsheet data source. Thank you!!!

I have seen some of your answers that have been useful to me, I would appreciate it if you could help me: @jaichith @Rachelgmoore @devingu @Mike_Procopio @Kirk_Masden @Aditya_K1999 @scott192 @lochtefeldm @Koichi_Tsuji @Stephane_fr 

[Kirk_Masden]

Hi @Mar02 !  And Happy New Year!

I use Google forms for classes almost every week.  However, I haven't done exactly what you want to do with an AppSheet app.  Still, I have a few thoughts.

On technique is  to make a read-only page on the Google spreadsheet you use with AppSheet.  Then, on the spreadsheet side, you can use IMPORTRANGE() to pull the data in.  Of course, the data would need to be formatted in the proper columns for your app.  To do that with a Google spreadsheet connected to a Google form, I find the ARRAY() formula to be quite helpful.