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

Feature Friday: Actions, UX, and Expressions


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!

Google Search

Subscribe Email