Multiple Google Forms into one Google sheet into an AppSheet

Hey everyone! I’m brand new to forms, spreadsheets and apps but am a firm believer that anything can be learned by watching YouTube videos and asking the internet. I’m trying to help my friend build an App to record her daughters seizures, medications, appointments, health etc. I have made 5 google forms called: Personal Health, Seizure Record, Medications, Overnight Information and Unusual Seizures. I’ve then linked all the form responses to a master spreadsheet and called each tab “xxx data”. Do I have to link the questions to the Master Spreadsheet for each form? Or just upload the 5 forms and Master into AppSheet? Or just the Master Spreadsheet? I wanted the landing page in the App to display the daily records that have been entered so I had made a tab in the Master sheet called “Daily Information”. But I stopped there because I wasn’t sure if my multi-form - one spreadsheet - one app would even work (and I’m I didn’t know how to do that!!). I really appreciate any help. I’ve discovered that not everything is easily learned by watching tutorials and reading instructions… Thank you so much for any advice!!

0 1 951
1 REPLY 1
Top Labels in this Space