Ranges are an effective means of creating arrays containing many
elements. However, it is easy to lose track of what elements they
contain, which can have surprising results. This tip explores this
topic in depth.
We work hard to ensure that your apps continue working, even as we
add features to Calcapp. With our new formula engine, we have made
some minor changes, but they should not affect your existing apps.
Colors can now be referenced with no risk of typos, thanks to
"enums." XLOOKUP, XMATCH and FORMATDATE also support enums, which
help warn you of errors early.
Panels have been renamed to screens to better reflect the
expectations of app authors. There are other name changes, which
better reflect how Calcapp is used today and how we expect it to be
used tomorrow.
Our next release will add a brand new formula engine, which will
support decimal commas in addition to decimal points in formulas. It
will also come with much-improved formula documentation and more than
100 new functions.
Ranges will enable authors to easily and concisely refer to multiple
values in formulas. Ranges, combined with the new function SUMIF,
will make conditionally summing values much easier than before.
When making changes to an app, you often need to share copies of your
changed app with a small circle of users before letting these changes
go live for all users. Read this tip to learn how this is done.
You can now reset your users' passwords directly from Calcapp
Creator. Use this feature if your users have trouble resetting their
own passwords or if you'd like to set their passwords for them.