AppSheet frequently asked questions (FAQ) for the IT department.
How are AppSheet apps created?
Apps are created on the AppSheet website. Each app is based on one or more "tables". It’s often the case that each table tied to a spreadsheet, but other forms of structured data can be used instead. The rest of the app is defined via configuration options. There is no code involved, so apps can be created in minutes.
How are AppSheet apps distributed?
What is the high-level architecture of AppSheet?
Each mobile app is based on structured backend data, typically a spreadsheet hosted on a cloud storage system like Google Drive, Dropbox, or Office 365. On the mobile device, a copy of the data is cached locally in order to permit offline operation. Whenever changes are made in the app, or when the users explicitly choose to sync the app, the changes from the app are moved to the backend spreadsheet and vice versa. All communication between the app and the backend data happens through the cloud-hosted AppSheet web service.
Where is AppSheet hosted?
AppSheet's web service is hosted on Google Cloud's web hosting infrastructure.
Can AppSheet be hosted on-premise within the company?
AppSheet apps can run from on-premise data, but the AppSheet platform is hosted in the cloud. It is not an on-premises service.
Is AppSheet reliable?
Is each app separately deployed via the iOS or Android app store?
Data Architecture FAQ
What sources of data can AppSheet access?
Do we have to use data in a spreadsheet?
AppSheet is meant for non-developers to easily build apps, which is why we have emphasized access to spreadsheets. We also support more traditional enterprise data sources for Enterprise subscription plan app creators.
Can you connect to our corporate database or resources behind a firewall?
Not directly. The AppSheet architecture permits our service to interact with data sources via a web service that acts as a proxy to the actual data. If the actual data is behind a firewall, you (or your IT department) will need to create a web service that acts as a proxy for the data. This is a relatively straightforward task for a web developer, and we can help enterprise customers with sample code for this proxy service.
Mobile Platform FAQ
What mobile platforms do you support?
AppSheet apps run on iOS and Android devices. We encourage iOS version 8.0 and higher, and Android version 4.3 and higher. Lower versions can cause subtle bugs or performance problems in certain scenarios.
Can the apps run in a browser?
Yes. While we primarily focus on mobile devices, many AppSheet customers also run their apps in a web browser, usually within an iframe. In fact, on unsupported mobile platforms like Windows Phone, we recommend running within a browser. Most of the app functionality is supported in a browser (except offline image caching and barcode scanning). We recommend a modern browser, and the apps work best on Chrome. AppSheet does not work on IE versions lower than V10.0.
Do you support feature X?
We add features to AppSheet at a rapid rate; it isn't uncommon for us to unblock a customer by adding a new feature in a couple of weeks. There is an active AppSheet community that drives and prioritizes our feature investments. All features are initially announced on the community for trial and added to the Appsheet documentation.
Where can I learn about the security model?
We have written a short article describing different aspects of the AppSheet security model. We're happy to share further details with IT experts.
What data does AppSheet store on its servers?
The AppSheet service records user signup information and access tokens in order to be able to access backend spreadsheet data. The definition of each app is also stored. The actual data used by each app is not copied to the AppSheet service. Instead, it passes through the AppSheet service as it flows between the mobile device and the backend cloud storage system chosen by the customer.
AppSheet does record usage events and also logs data updates in order to support diagnostics, debugging, analytics, and billing. We're introducing an option for customers to limit the duration for which this information stays in the system logs.
Has AppSheet passed security and/or privacy audits?
Support and Services FAQ
What is the response time for product support questions?
Our user community forum is the venue for most support questions. Not only is every member of our team actively engaged with user questions, we also have power users: community moderators who help all members of the AppSheet community with questions and issues. Most issues are responded-to within hours and resolved within the day. We also offer prioritized support for customers in higher subscription plans.
Do you provide professional services for app development?
We try to focus on core platform development. For some key strategic engagements, we can help customers with app development. We prefer our customers work with one of our solution partners: professionals who are experts on the AppSheet platform. Depending on your needs, we can identify suitable solution partners.