Here at AppSheet, we only make changes to our service if we know first that those changes will affect positive outcomes for you and your business.
In this vein we continue to add features to our platform based on feedback that we get from our interactions with users. Recently we've added a few features we hope will add new levels of functionality and enhancement to your apps.
Click the features below to see how they work.
Add More Extensive Refinement to Your App Data
We've added a few features that will allow you to interact with your data in richer ways.
You can specify more than one column as the key in your app. This will combine the columns you choose, showing all chosen columns’ values next to each other in the app. You would do this to create a more refined key with only the data from the columns of your choice.
In some apps, it is important to record a timestamp or increment a counter automatically in a row when changes are made to other columns. Before, change types reflected ALL changes made to the data in a particular row in the app. Now, you can increment a counter that only responds to changes to specific values within the columns.
A table reference column allows one column of a row to reference an entire row in another table or sheet. For example, an Order entry has a ProductId column to reference a specific product. We’ve now additionally added the ability for such a column to reference a table slice instead of an entire table. The data type is called 'Ref'. This allows apps to specify richer constraints, especially in forms-based data capture.
Sometimes, it may be useful to know where someone was when he or she made a change to the data in the app. You can use a ChangeLocation data type to implement this function.
Just as the ChangeTimestamp and ChangeCounter let you know when and how many times an entry was last edited, the ChangeLocation type will automatically populate with the current GPS location (where the change was made).
Google Forms have a question type that allows the user to select multiple answers on a question. But before, we only allowed one selection via a dropdown menu. Now, users can select multiple options. The data type is called 'EnumList'.
AppSheet represents this as a menu in the app, and the user can select one or more answers from the menu by holding down the Shift key and selecting.
Check for Deployment Readiness and Transfer App Ownership
We've added a number of checks you can perform to make sure your app is ready for use and deployment.
On your Account page, AppSheet has provided you with a list of all of your apps and detailed information about them. Here you can see if your apps are runnable and deployable, what kinds of features they have, what type of plan is required for each app, and each app’s usage stats.
Clicking the ‘Stats’ link allows you to see, in graph form, statistics about your app, including unique users per month and per day.
You can transfer your ownership of any app to another user. This means the new user will have full control of the app's permissions and setup. Do this in the Advanced Editor.
Add a New Presentation Type: 'Form'
In addition to the list, gallery, map, and chart data views we provide, we have added a view option that allows your app to simply act as a form.
You can use AppSheet for Google Forms to both distribute forms through a mobile app as well as use a mobile app to view and interact with form responses. But if you’re only using your app to distribute forms, you probably don’t want your app showing each user’s response, and instead have each new user simply be able to fill out a new form with the app. You can do this by selecting the 'Form' option from the list of presentation view types.
Use Your Data from Office 365
In addition to the platforms we already host (Google Drive, Dropbox, Box, Smartsheet), you can now also log in from your Office 365 account.
We’ve added the ability to use AppSheet with your Office 365 or OneDrive account. Simply sign in on www.appsheet.com and click the Office365 button.