You can use formulas to calculate the initial values of input fields, which
are the values displayed before your user changes them. These formulas
typically take into account the values entered on a previous panel.
Is it possible to customize what fields are reset by a reset button? How can
an app designer determine what fields are included in a report? Dave asked us
these questions and received a lengthy reply from our co-founder David.
There is no built-in way to display a time duration in your apps, but you can
easily use formulas to achieve the same result. Read this tip to learn how to
display time durations like "1:05", indicating that one hour and five minutes
Our next release enables you to remove panels without also removing the panels
that follow them. As a result, you can now do things like removing the first
panel of an app without touching the rest of the app.
The new Panels sidebar allows you to quickly move to individual panels. You
can also reorganize panels by dragging and dropping them. For better control
of your panel structure, copy and paste panels instead.
Our next release will allow you to insert panels anywhere in your app. You
will also be able to copy and paste panels and fields and other items. A new
sidebar will give you an overview of your panels and enable you to reorder
Spreadsheet formulas usually use position-based references like A2 to refer to
cells while Calcapp formulas use names. Rewriting formulas manually when
you're converting a spreadsheet to an app is tedious and error-prone. This
post explains how you can make Calcapp Creator do the work for you.