<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Subscribe to Our Blog Stay up to date with the latest tips and news.
Filter By:
Sort By:

Jennifer Cadence

Jennifer Cadence
Jennifer helps AppSheet creators learn and love our platform.

Recent Posts

Feature Friday: Exciting News, New Card View, and Onboarding View Update

Welcome back to AppSheet’s Feature Friday where we showcase our favorite features. This quick guide will help you build your apps faster so you can focus on what matters.    Have you heard our big news?  Last week we announced that AppSheet is joining the Google Cloud team. We’re incredibly excited for this next step in our journey and most importantly, we’re excited to have you join us. For more information on our future with Google, please read this letter from our AppSheet CEO Praveen.   Improved Card View   We discussed this release in our recent Office Hours session, but in case you missed it, here’s a quick overview. This improved card view gives you much more flexibility and allows your app to have that custom feel you’ve been hoping for. You can even create a kanban board layout with this view type.  We anticipate more updates in the future, keep an eye on this thread to ensure that you remain up to date on how we continue to improve this view.  Onboarding View It's easy to overlook one of the most challenging parts of creating and deploying applications to a team: app user adoption. In order to help your users understand why your application is useful and how to best take advantage of it, we've introduced a dedicated 'Onboarding' view type. This view works like any of our other first class views, working directly from a table of data that contains visual and text instructions. You can construct multiple pages that app users swipe through when they first open the application, rather than the single static 'About' page that existed previously. How will you use these new features in what you’re creating? Stop by the AppSheet community and let us know! Happy app building!    

Feature Friday: Top Ten Empowering Features of the Year

Welcome back to AppSheet’s Feature Friday where we showcase our favorite features. To close out 2019, we wanted to highlight the top feature releases of the year. We took this list very seriously, in part because we released so much this year that it made our heads spin. Rather than rehash the data pulls and heart breaks over what made the list, we’ll take you straight to the good stuff.  The Top Ten 10. File Generating Workflows If you work with workflows, chances are you also use the "Save File" feature. Because of its popularity, we grew this feature over the course of 2019 to include custom PDF sizes, .ics calendar invites, and more. To learn more about the “so awesome”capability of this feature, see how the AppSheet Community has been using it. 9. SNAPSHOT() SNAPSHOT() is a new release, but within the first few days of availability it was used more than 3000 times. For those of you that have applications that incorporate daily inspection reports of a worksite or you have large amounts of data displayed in a dashboard that you would like to send to your executive team automatically, this is a great expression to add.  8. Bulk Select The small but mighty action that made a big impact for applications built by everyone in the AppSheet Community, including our staff. With this feature you can scroll through the view highlighting the rows where you want to apply a normal action. If you've never used it before, there's a sample app included below where you can give it a whirl.  7. Data: execute an action on a set of rows As displayed below, there are a number of actions you can take to modify data or navigation within your application. One of the purposes of these action types is to save you time and make your applications more efficient. If you're looking for an automated version of the popular bulk select feature, this action makes that happen. 6. Customizable Dashboards Interactive mode, tabs, and custom sizing all provided new and powerful ways to display your data in this view type. according to fellow Creators, “The dashboards and data analytics side of app sheet is honestly my favorite.” The data supports this too, with tens of thousands of dashboards being added to applications this year.    5. Add a new row to another table using values from this row Released this summer, this action has been a hot topic. With this action you can specify which separate table data should be added to while defining each column added, allowing rows of data to quickly be updated and moved across all tables in your application.  4. Predictive Values Need to estimate the cost of a project or predict customer churn? You'll love predictive values. Technically we released a beta of this feature in late 2018, but we’ve made so many updates to it this year that it was an absolute must to include on this list.  3. Predictive Classification If you've ever wondered why we call ourselves an "Intelligent Platform" this is one of the reasons why. This release plus a little machine learning can help improve your apps in countless ways.    2. Map Point Grouping Maps can become very cluttered very, very quickly. We wanted to help avoid this often frustrating display issue by giving you the option of grouping your pins together or leaving them separate on your map display.  1. Optical Character Recognition (OCR) Extracting information such as prices or names from an image became possible this year. Since the beta release in late July, this feature has been used in thousands of applications making it number one on our list for a reason. It’s highly customizable, powerful, and a complete game changer.    That’s a wrap on the top features of the year! Stop by the AppSheet community to let us know what your favorite feature of the year was.  Thank you all for a fantastic 2019 and a very Happy New Year!   

Feature Friday: Duration, CONTEXT() Updates, and a New Onboarding View

Welcome back to AppSheet’s Feature Friday where we showcase our favorite features. This quick guide will help you build your apps faster so you can focus on what matters.  Duration  Duration is part of the Date and Time expression family and allows you to calculate duration of seconds, minute, or hours. This has been expanded to make it easier to compute intervals in TOTALSECONDS(), TOTALMINUTES(), and TOTALHOURS(). These functions are great ways to track hours worked by your employees or manage duration of time spent on a project.   CONTEXT() Update The function CONTEXT(option) is used to return a Text value that indicates where in the app this expression is being used. It's useful for "meta-data" operations but in a rather limited scope. We've expanded the functionality to include a fourth option, CONTEXT("AppName"). You can take a deeper dive into the technical side of CONTEXT() functions in reviewing this help document.  Coming Soon: New Onboarding View  The “About View” that your users currently interact with is rather static. To improve the experience for onboarding those that use your applications, keep an eye out for a soon to be released “Onboarding View.” You’ll have multiple pages for content, swiping capabilities and more.  Top Features of the Year  Next week we will be releasing our list of the Top Ten Features of the Year. stay tuned to see if your favorite made the list!    How will you use these new features in what you’re creating? Stop by the AppSheet community and let us know! Happy app building!

Feature Friday: Intersect, Table Sorting, and ICS Calendar

Welcome back to AppSheet’s Feature Friday where we showcase our favorite features. This quick guide will help you build your apps faster so you can focus on what matters.    INTERSECT() Are you a list person? If so, then you probably have a few lists running with common items that you wish you could manage differently. We’d like to give you a bit of sanity back by introducing you to our INTERSECT() function.  Whether you're managing inventory or events, you’re going to want to go straight to your editor and add this function. It takes all the elements which are common to both of the original lists and stores them in another list. The newly created list becomes a summary of the elements that we similar.  Our community has had a few days to work with this feature and has some great suggestions on how to implement this new expression. To learn more stop by the AppSheet Community.  Table Sorting in Dashboards A small but mighty feature, this update allows Tables displayed in Dashboards to be sorted by their headers. Previously, Tables that displayed in Dashboards were relatively static. This new capability, however, provides a more interactive way to present your data.  We introduced this update in our new and improved Office Hours this week. If you missed the session, we've got you covered.    ICS Calendar Attachments   We're expanding the options available for the file types that can be sent in your workflows. The latest addition is the ICS Calendar (also known as .ics) which allows you to send calendar invitations in an email message. If you've received a meeting request or event invitation in an email, you've used .ics before.  This workflow update can be used for sending calendar information for everything from formal meeting requests to surprise party invites. Information sent in your .ics file can include location, date, time and more. To learn more about working with workflows, review our workflow support series.  How will you use these new features in what you’re creating? Stop by the AppSheet community and let us know! Happy app building!

Feature Friday: DateTime, New “Save” Button, and Enterprise Updates

Welcome back to AppSheet’s Feature Friday where we showcase our favorite features. This quick guide will help you build your apps faster so you can focus on what matters.    DateTime  Have you been waiting for the ability of 24-hour format selection regardless of locale? Good news, you can! You can learn more about this new expression in the TEXT() document, but here’s a look at the function itself.  TEXT(DATETIME("2019-11-01 1:34 PM"), "HH:MM") returns 13:34 For the non-engineers who may be wondering what a 24-hour format DateTime selection is, here's a quick breakdown. DateTime is an expression that displays time in what some call "military time" (ex: 06:00pm would be 18:00). Some locales typically default to 12 hour formats while other locales default to 24 hour formats. When you use this new expression your locale no longer matters. This is great for those who work with different users across the globe.  New “Save” button  The floating “Save” button is getting a makeover. If you've been around AppSheet for some time you're probably used to seeing this in your nested menus when it's time to save the work that you’ve done:  With the recent change, your "Save" button now looks like this:  This update brought the addition of a few keyboard shortcuts, and the ability to both Undo and Redo items in your editor. It can be found in its new location, your primary navigation bar. Enterprise Updates  If you benefit from working with an Enterprise plan, a few administrative updates are taking place. The ability to transfer all applications (think bulk action) grants a Root Admin the ability to transfer applications from one user to another. This is a great way to manage access when someone on your account no longer needs to manage applications.  The Enterprise Dashboard has also been redesigned and will include a search bar to the shared apps tab, you can take a look at a preview below.  Coming Soon: Improved Card View  More UX changes are on the way and this time it’s the Card View. You’ll be able to configure layouts by clicking on elements and when data is loading, the layout will show animated UI skeletons. Make sure to follow along in the Community to see when it becomes available.  How will you use these new features in what you’re creating? Stop by the AppSheet community and let us know!  Happy app building!

Feature Black Friday

Happy Black Friday! Take some time to digest our favorite new features from the last month. And you don't even have to wake up at the dawn to get cracking on using these in your latest apps. SNAPSHOT() Use this expression to embed charts & maps in workflow generated emails & PDFs, for richer notifications, documents and reports. Range of Rows A simple update that will save you time is the ability to select multiple rows (or items) and perform an action.  Webhook Generating Form Post Customize and control the content and format for your webhook body with a template.  EXTRACT() Extract selected values from your text by implementing this new expression.  UX Color Schemes Choose from “dark” or “light” color schemes to have a cohesive UX experience in your applications.  Stay current with our feature updates by attending one of our upcoming webinars.

Feature Friday: UX color schemes, a sneak peek, and SVG

Welcome back to AppSheet’s Feature Friday where we showcase our favorite features. This quick guide will help you build your apps faster so you can focus on what matters. UX color scheme updates  If you’ve created a new app recently, you’ve probably noticed a change to the color scheme selections. We’ve updated the choices available to select either a light color scheme or a dark color scheme paired with your button color of choice. This is a temporary, incremental part of some of the improvements we’ll be making to the branding capabilities in your AppSheet editor. As part of this change, we’d love to hear more from you, our app creators. Because of this we’ll have a few members of our team who work closely with UX in our Office Hours session on Tuesday, November 26th. During that time you’ll be able to provide feedback and ask UX related questions. Register here if you’re interested in attending. Scalable Vector Graphics (SVG)  A topic that’s been trending in our community as of late has been working with Scalable Vector Graphics. For those new to this concept, SVG is a graphic format based on XML and is used to display a wide variety of graphics in digital environments. This is a great way to improve logo designs, images used on PDFs, and more. Coming soon: improved Emulator  Over the next few weeks we’ll slowly be rolling out an important improvement. The Emulator in your AppSheet editor is getting a makeover to improve your app creation experience. Soon, you’ll see sleeker aesthetics, have the ability to preview different form factors without leaving the editor page, and jump straight to to full screen application.  How will you use these new features in what you’re creating? Stop by the AppSheet community and let us know! Happy app building!  

Feature Friday: SNAPSHOT() your data and EXTRACT()

Welcome back to AppSheet’s Feature Friday where we showcase our favorite features. This quick guide will help you build your apps faster so you can focus on what matters. Take a SNAPSHOT() of your data  We have to admit, we’re excited about this one. Let’s say you have an application that incorporates daily inspection reports of a worksite or you have large amounts of data displayed in a dashboard that you would like to send to your executive team automatically. The SNAPSHOT() addition to workflows allows you to take static images of charts, graphs or custom maps and add them to either PDF attachments or emails sent from your application’s workflow. This feature leverages the LINKTOFORM() expression but requires the addition of SNAPSHOT() to the template formula. To add to your applications functionality, navigate in your app editor to Behavior > Reports or Workflows. From here, select or add the action that you would like to contain the SNAPSHOT() template. There are a few additional steps to take and we recommend reviewing the final steps of this process in our help center.  EXTRACT() information from text A BETA release that allows you to extract a wide variety of information (values) from text. Have an image of a mailing list full of emails? Want to parse prices from receipts? All of this and more can be accomplished by inputting the keyword option value you’d like extracted from text. Below are a few examples to demonstrate. Note that the “LIST” items at the end of each example  are the values that have been extracted based on the stated value. EXTRACT("PRICES", "So, we've got a frappuccino for $3.49, a chocolate muffin for $2.49, and a chocolate milk for 99 cents, for a total of $6.97. Will that be all?"): LIST(3.49, 2.49, 0.99, 6.97) EXTRACT("DATETIMES", "Set a meeting for November 14th at 4pm"): LIST(DATETIME("11/14/2019 16:00:00")) (replace 2019 with whatever the current year is, if you're reading this in the future) EXTRACTEMAILS("Mailing List: a@a.com, b@b.com, c@c.com”) : LIST(“a@a.com”, “b@a.com”, “c@a.com”) To view the complete list of EXTRACT formulas, start with this article. How will you use these new features in your app building? Stop by the AppSheet community and let us know! Happy app building!

Feature Friday: Range of Rows, Webhook Generating Form Post, and The Power of Dashboards

Welcome back to AppSheet’s Feature Friday where we showcase our favorite features. This quick guide will help you build your apps faster so you can focus on what matters. AppSheet Staff Favorite: Dashboards One of our team’s favorite ways to display data is with the Dashboard view. Why are we in love with the dashboard view? Customization! The dashboard view's ability to access multiple views, as well as filter data interactively, allow you to display a diverse set of view types (e.g. charts, details, tables, etc.) in one quick snapshot. Did we mention it’s also a great default view for your app’s users? In addition, the feature helps you take advantage of the larger screen sizes on computer browsers. Many of our views are designed for mobile and tablet, but if you’re viewing your app on a desktop or laptop computer, dashboards are the powerhouse view. Webhook Generating Form Post  Our product improvements are always inspired by you, the AppSheet Creator. This recent release is a great example of how your input shapes what we come out with next.  Workflows have already given you a more powerful way to make your applications your own, but we’ve added another way to customize. With webhook generating form posts you can now customize and control the content and format for your webhook body with a template. You can learn more about the webhook feature in the AppSheet Community. Range of rows A simple update that will save you time is the ability to select multiple rows (or items) and perform an action. To use this feature, you’ll need to ensure you’ve enabled Quick Edit in your applications UX settings. How will you use these new features in your app building? Stop by the AppSheet community and let us know. Happy app building!

1of2