In this article, we've put together an "FAQ for IT". Many of the topics have more detailed information in other articles in our help site.
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?
Apps are distributed by sending an install email to desired users with an install link. Users open the install email on a mobile device, click on the install link, and can install the apps instantly.
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?
The AppSheet web service is highly reliable with 99.99% monthly uptime. The reliability derives from both the redundant cloud architecture as well as the reliability of the underlying Google Cloud infrastructure services. The greatest source of reliability concerns for a mobile app stem from connectivity issues. AppSheet is explicitly designed for environments with bad or intermittent connectivity, and the data synchronization technology handles various kinds of failures seamlessly without data loss.
Is each app separately deployed via the iOS or Android app store?
No. Mobile apps run on the device within a common "host" app called AppSheet. This host app is already available in the iOS and Android app stores. This allows any new app to be instantly deployable.
Data Architecture Questions
What sources of data can AppSheet access?
AppSheet apps can access spreadsheet data from Google Drive, Office 365, Dropbox, Box, and Smartsheet. More data sources are being added actively. AppSheet also supports connectors to Salesforce and SQL databases for Enterprise subscription plans.
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 Questions
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 user community that drives and prioritizes our feature investments. All features are initially announced via the community for trial and then promptly added to the help docs.
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?
As a startup company, we have focused for the last year on building a secure and scalable architecture. We have designed for security and for data privacy. Over the next year, we'll be working with established auditors to gain official compliance certifications.
Support and Services Questions
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.