Iteration means that a value is calculated by performing a number of
steps, where the result of the previous step is fed into the current
step. Use REDUCE to implement iteration with Calcapp.
Calcapp will become significantly better in the coming months. Action
formulas will enable buttons to run formulas, and a new data editor
will allow you to easily incorporate spreadsheet data into your apps.
Can the switch field selections made by a user be summed up in a
single text field sentence? Yes, and there are two ways to do it, one
using old-style formulas and one using the new formula engine we
introduced in November.
In this post, we create an app that displays all legal US holidays
for a given year. The app adapts a formula created for Microsoft
Excel and uses new functions introduced with our new formula engine,
like FORMATDATE, FILTER and TEXTJOIN.
When formatting dates, you can choose from five pre-defined date
formats. What if you want a custom date format? For output fields,
you can use text fields and formulas to achieve this. This post
explores two formula approaches.
Our biggest release ever is here, celebrated with 23 blog posts. Use
100+ new functions, including XLOOKUP and SUMIFS. Determine the next
screen and what fields are included in a report using formulas.
Several thousand formula examples help you get started with all the
new features.
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!)