<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Back to Blog Listing
Jennifer Cadence
 |  May 15, 2020

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. 

A teacher drawing the map of the world on a blackboard with a chalk


GETY and GETX functions

For those that work with locations, we’ve added a few additional functions: 

  • GETX(xy) returns the X portion of an XY value as a decimal value in the range +100.000000 to -100.000000.
  • GETY(xy) returns the Y portion of an XY value as a decimal value in the range +100.000000 to -100.000000.

These functions are a fantastic alternative to LatLong related functions. You can learn more about these function types in our Expression Types article series. 

XY Maps with version control 

Column types are an important piece of the data design process. One of these column types, XY, represents a position within an image that you provide. This column type is used most often with the Maps UX view type. When a Map view is configured with an XY-type MapColumn, it will display the image in place of the usual map. This data type is commonly used for applications developed for manufacturing, field work and inventory management but there are a number of other ways in which to leverage this functionality. 

One of the challenges of working with this type of data, however, is that the pins associated with these maps could shift if updated maps were not the exact same crop and scale as the previous version. To solve for this, we built the below demo app. This post in our Creator Community contains a detailed walk through of working with this application.


The concept of slices is one of the most popular topics for app Creators. Because of this, we want to dive a little deeper. Our upcoming Office Hours on Tuesday, May 19th will feature an in depth conversation on slices and user roles. You can submit your questions and sign up for the session here. 

If you’re unfamiliar with the concept of a slice, it’s a subset of the rows, columns, and actions of a table. A slice definition has five components. 

  1. The table it's based on (required)
  2. Does the slice permit adds, deletes, and updates? (required)
  3. The subset of rows it retains from the table (optional)
  4. The subset of columns it retains from the table (optional)
  5. The subset of actions it retains from the table (optional)

You can learn more about slices and how to implement them in our support documentation.

How will you use these features in what you’re creating? Stop by the AppSheet community and let us know! Want to spend time with our team? Register for our next Office Hours session for additional Q&A. 

Happy app building!

Post Comment
Jennifer Cadence

Jennifer helps AppSheet creators learn and love our platform.

[Features, Tips & Webinars]