If a function isn't returning the value you expect, you need to look
at the parameters it receives by creating new temporary fields
visualizing the parameters. To do so with an array, you need to
convert it to a text string first using the TEXTJOIN function.
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.
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