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