Visualize Form responses through a mobile app, host your Forms in a mobile app to give to folks to fill out, or both!
The Google Forms AppSheet add-on works much the same way as the Sheets add-on, with one exception.
To be able to correctly interpret the Form data and allow you to see responses, Google produces a 'response' Google Sheet for each Form. This Sheet is what AppSheet uses to generate a mobile app. See the figure below to visualize the process.
Getting Your Forms Mobile
Once you have installed the AppSheet Forms add-on, have received a couple of responses, and are ready to make an app, click 'Go' in the AppSheet pane that pops up on the right of your screen. You'll then be taken to AppSheet.com where you can edit and customize the app as well as view the response Sheet. Note: it's generally a good practice to wait until you have a few responses before generating a mobile app, so AppSheet has a populated spreadsheet to work with.
Google Forms features several question types: text, paragraph text, multiple choice, choose from a list, scale, grid, date, and time. AppSheet automatically carries over the formatting of your Google Forms questions to the Google Sheet in ways that are compatible with our apps' functionalities. However, AppSheet makes a few modifications on those question types that work within the mobile app environment, and indicates them as comments on the headers of the columns.
I made a sample form, one that a hotel may give to its patrons to answer questions about their stay. Continue reading to see how AppSheet interprets the Google Forms question types.
How AppSheet Presents Google Forms Question Types