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.
Text fields with multiple lines work great for displaying text you "calculate"
using a formula. Read this tip to learn how to include quotation marks in
calculated text.
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
have elapsed.
Copy and paste panels, fields and other items. Use the new Panels sidebar to
reorder your panels and quickly navigate to them. Insert panels anywhere in
your app.
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.
Use our new copy and paste feature to copy fields and other items from one
panel to another or to copy entire panels. This is a great way to copy data
from one app to another.
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
them.
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.
Calcapp enables you to create apps that might otherwise have been
created using a spreadsheet. Create apps yourself without
time-consuming and expensive custom software development.