Our most significant release yet is here, with 23 blog posts to
describe it all. Build previously-unthinkable apps with action
formulas. Import and edit spreadsheet-like data and use eleven new
button types. The app designer now supports undo, formula
autocomplete, a new email editor and much more.
Eleven new types of buttons make your apps easier to use and more
powerful. Buttons can run action formulas, change the active screen,
copy text to the clipboard, show messages and more.
Action formulas make things happen, unlike regular functions, which
calculate values. They are our biggest new feature yet. Use them to
model complex business logic.
Our new data editor allows you to easily create and edit
spreadsheet-like data tables. Data can be imported from spreadsheets
through copy and paste. Use XLOOKUP to look up values in data tables.
We are introducing a new set of plans at higher price points.
Existing apps stay on the old plans at the old prices, with access to
most of our new features. The new button types, the data editor,
named values and action formulas require you to upgrade to a 2023
plan.
Our new formula autocomplete system provides helpful suggestions for
what you may want to type next. To reference a field on any screen,
just type part of its name or label and let us do the rest.
All text properties can now be edited as templates. Change the text
as you normally would in the inspector and insert formula fragments
between special markers. This makes it much easier to edit email
bodies sent by your app.
The new Items property allows you to access all items, including
fields and buttons, as a single array. That makes it easy to
calculate the sum of all fields of a screen, or determine if all
fields of your app are valid, with short, readable formulas.