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.
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.