It's been an exciting year since AppSheet first launched in October 2014. Back then we were still learning about the needs of our users, but we were committed to listening to customers and making decisions based on their needs.
One year later, we've received thousands of feature requests, and based on those, built a powerful tool for business productivity that has attracted close to 40,000 users in more than 150 countries. It's safe to say we're planning to stick around for the long-haul.
All along we've been adding features to make apps more powerful and providing more options and flexibility in the app creation process. Most of these additions have been based directly upon user feedback-- comments from customers who are innovating and building amazing apps every day. Our User Community has grown to more than 1,400 members, several of whom have become Community moderators as a result of their participation and mastery of the platform. We are constantly impressed by our users, their ideas, and the apps they create.
Below we rounded up some of the best features of the past year to get you thinking about what kinds of things you can do with your apps. We thought it would be helpful to see the important platform additions all in one place-- and fun to see just how much has changed in a year!
- Filter rows by date and time
You can use slices to choose what data to display in the app.
- Choose a specific worksheet
Specify any worksheet in your workbook, or include multiple worksheets in your app.
- Customize your app's font
Choose from six fonts and several different font sizes.
- GPS location functionality
The LatLong Column Type helps you capture GPS locations in your apps.
- Barcode scanner
Check the "Scan" checkbox to create a barcode scanner in your apps-- since most smartphones come pre-loaded with scanning capability, no additional app is needed. Check out our Store Inventory app to see how it works.
- Show column headers in the app
You can choose to display column headers in your apps for more clarity in the display of data.
- Generate a random value for key fields
Unique keys are helpful if you need each row to be assigned a a unique value not chosen by the user.
- Google Forms add-on
Turn your Google Forms into mobile apps with this convenient add-on.
- Support for Smartsheet
Connect your Smartsheet data to AppSheet straight from your Smartsheet account.
- Prepare app for deployment
We implemented a series of checks to ensure your app is deployable, reminding you to fix errors and add branding so your app is ready for launch.
- Transfer app ownership
From the Settings>Security tab, you can choose to give ownership of an app to another user who will then hold the editing and customizing rights.
- Weekly status emails
These emails are designed to provide usage statistics for all of your apps based on whether they are deployable, their plan requirements, usage data, and more.
- Workflow rules
Send or receive emails when data is added or updated in the app.
- Delayed sync
If you're working offline, the Delayed Sync option allows you to postpone syncing until you're back on the network.
- Multiple key columns
You can combine key columns if just one column's data isn't unique enough to act as the sole key.
- PDF attachments for workflow emails
You can choose to include a PDF attachment in workflow emails sent when data is added or updated.
- Show type
Use the Show type to embed images and videos into your forms. Check out the Movie Survey sample app to see how it works.
- Default button naming
Rename the default buttons in your apps to your preferred language or terminology.
- Conditional formatting
Use colors and icons to affect the way information is displayed in your apps. Check out the Service Log sample app to see how it works.
- Theme colors
Choose from a set of 30 theme colors with dark and light background options.
- Conditional branching
Break input forms into pages and choose to show or hide questions based on previous answers in the form.
- Office 365 add-in
Connect to AppSheet from an Excel document with your Office 365 or OneDrive account.
- App formulas
Use app formulas to compute simple calculations straight from within the app.
Expressions allow you to compute new values from existing values.
- Google Docs add-on
The Google Docs AppSheet add-on is the fastest way to turn paper-based forms into mobile apps.
- Table view
The table view is ideal for handling larger data sets.
- Virtual columns
Use virtual columns to compute data in the app that doesn't live in the spreadsheet.
- Icons as UX views
You can set your UX views to display custom icons.