AppSheet automatically creates a mobile app:
- Based on your data.
- Designed for a mobile device.
Based on Your Data
AppSheet automatically creates a mobile app based on the structure of your data.
AppSheet automatically infers the structure of your data from the spreadsheet you provide. AppSheet creates a 'table' for each worksheet. A 'table' is a collection of rows with uniformly structured columns.
AppSheet automatically infers the data type of each column in your spreadsheet, such as text, number, date, time, image, etc. It recognizes more than 20 data types. AppSheet also automatically groups related columns to form composite columns. For example, FirstName, MiddleName, and LastName are recognized and treated as a 'Name'. Street, City, State, Zip, and Country are recognized and treated as an 'Address'. These inferences happen automatically but you can override them.
Data values are automatically displayed based on their type. For example:
- An address column is geocoded and shown on a map.
- A phone number column can be dialed or texted.
- A numeric column can be displayed in a chart.
If you permit data to be added or updated, AppSheet automatically generates an input form based on the column types. For example:
- An image column automatically launches the camera.
- A drawing column captures a digital sketch.
- A signature column captures a digital signature.
- A text or number column can be bar code scanned.
AppSheet automatically creates views of your data. You can customize these views.
In short, the app creator defines the structure of data; AppSheet creates an app based on that structure.
Your app will not look like a mobile spreadsheet. Your spreadsheet is a data source, but you are creating a real mobile app.
Designed for a Mobile Device
AppSheet creates an app designed for a mobile device.
- Mobile devices have limited screen sizes, so each data row is presented using mobile-optimized patterns.
- Most data views are summary views that expand to show the full details when an entry is clicked/tapped.
- In summary views, we show the key value and as many other columns as possible.
- Actionable values (that launch actions when you tap them) like phone numbers and emails are preferentially shown.
- Columns on the left of the spreadsheet are considered more important than columns on the right.
- If there is an Image column, it is populated by taking a photo with the camera.
- Signatures can be captured on the touch screen. See how the signature feature works in our Delivery Tracking sample app.
- Enumerated types (defined by data validation lists in the spreadsheet) get a dropdown list to choose from.