<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Back to Blog Listing
Santiago Uribe
 |  June 30, 2017


As the summer starts, we want to remind you of features that we recently added to the platform. Today is mainly about Actions. But there are other goodies as well!

Learn more about copying rows, new action buttons, new formulas, background sync, and more!

Copy Rows

If you have rows in your table that you'd like to use to pre-fill a new form, the new Copy Row action is for you. This new feature enables you to copy all of the columns in a row with a single action button. When you click on Copy, you'll be taken to a form view where you can modify the data.


Copy rows is available under Behavior > Actions >

While you're there, check out other great action types for your apps!

New Action Types

In preparation for upcoming changes to Actions, we've added four new action types that allow you to create actions like never before. The four types do what you expect: compose an email, start a call, compose an SMS (with optional message text), and open a file (similar to an action column).

New Actions
Our capabilities with Actions will continue to expand, letting you create richer apps. 
These new action types are available under Behavior > Actions > Effect 

Sort by Column Headers

We've had a lot of requests for this feature. In the table view you can now tap on the column headers to sort the table by that column. Tap once to sort Ascending, tap again to sort Descending.


To use this feature, you'll need to turn on "Explicit Column Headers" in UX > Options.

App Icons

We updated the default icons in AppSheet. Now you can select from 20 icons or upload/link to your own. If your apps run on android, the default icons will have a transparent background, making them look even nicer.


App Icon (Logo) is available in UX > Brand > App Logo

...And two more new features:

Auto Background Sync

Automatic background sync now checks every 30 minutes to see if there are any new data to update. It does so without disrupting the running app; when the app user switches view, the new data is added to the app. 

Auto Background Sync is available in Behavior > Offline & Sync

Max Row / Min Row

Have you ever wanted to find the most recently created row in a table? You can do this using our new MAXROW and MINROW functions. Some examples:

MAXROW(Customers, SignupDate)  – returns the most recently created customer.

MAXROW(Customers, SignupDate, [State] = WA)  – returns the most recently created customer from WA state.

MINROW(Customers, SignupDate)  – returns the first customer to sign up

You can use MAXROW and MINROW in the Expression Builder.

That's all for now. See you next week, don't forget to follow us on Facebook, Twitter or Linkedin!

Post Comment
Santiago Uribe

Santiago is the VP of Product at AppSheet. He is a relentless customer advocate. He loves building partnerships and driving customer adoption. Prior to AppSheet, Santiago worked at Microsoft, got an MBA from CMU and worked in international trade development in New York and Bogota, Colombia.

[Features, Tips & Webinars]