Use the IF formula function to make logical comparisons when
calculating values. To use multiple criteria, use the logical
functions AND, OR and NOT. To make formulas read better, consider
using Calcapp's &&, || and ! operators instead.
Make your apps look stunning by selecting a custom color scheme. All
colors can be selected using formulas, enabling you to create field
validation that really stands out or let your users select their
preferred color scheme.
How do you convey that a field is 62 percent invalid? By assigning a
background color to the field that gets more intense the less valid
the field is! Read this tip to learn how to use the new BRIGHTEN
function to achieve this.
Colors can be selected using formulas that take into account values
entered by your users. You can use this feature to create field
validation that really stands out or to enable your users to select
their preferred color scheme.
Give your apps a custom color scheme by setting only a few base
colors and Calcapp will figure out the rest. You can also set colors
individually for precise control.
The new color picker allows you to select the colors used in your
app. You can select colors either from a palette with colors that
work well together or any color by selecting a hue, saturation and
brightness. It also supports entering named colors and colors from
the color models RGB, HSL and HSB (HSV).
Calcapp will move to a new cloud provider in September to ensure that
we continue to deliver a great experience as we grow. The service may
be unavailable during short intervals when we make the switch, but
apps you have already accessed or installed should continue to work.
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.