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.
When multiple items are checked in the app designer that use the same
formula, this shared formula can now be edited. We also describe the
new special formula value Item and the related performance
improvements we've made.
The screens sidebar can now be resized, line breaks can be inserted
into formulas, sliders work better on touch screens and you get more
disk space for images. Our latest release is full of minor features
such as these.
The new function LET enables you to assign names to values for use
inside a single formula. LET can make formulas shorter and easier to
read and can help them run faster.
Named values allow you to assign names to values returned from
formulas. Unlike hidden fields, named values can represent anything a
formula can return, including screens and arrays.