After two years, our new formula engine is finally ready. It powers
more than 100 new functions, operators and properties, making more
types of apps possible than ever before.
We now support 102 new functions, including Excel 2021 marvels like
XLOOKUP and FILTER, spreadsheet classics like SUMIF, COUNTIFS, INDEX
and MATCH as well as the power user favorites MAP and REDUCE.
Calcapp now supports arrays and ranges. Arrays are collections of
values which enable many of our new functions and properties. A range
is a short-hand for constructing arrays with many elements. (Need to
sum 100 fields? Easy!)
Excel 2021's XLOOKUP function is now fully supported. It does
everything VLOOKUP and HLOOKUP do and more. Use an app to convert
table data to XLOOKUP formulas.
Fully determine the bodies of emails you send using formulas. You can
also use formulas to set text that appears before or after field
values in reports.
Get full control over your reports. Want to only include fields with
values greater than five? Just use FILTER. Also, hidden fields can
now be left out of reports.
Skip straight to the results if the entered data checks out, or
collect supplemental information otherwise. Stop copying and pasting
screens — now you can make many screens send the user to the same
destination.
What's got half a million words? The Lord of the Rings trilogy. And
our new formula and property documentation, which is now on the web.
Thousands of formula examples make getting started with all the new
features easy.