Date and time fields can be instructed to display a default value
that appears when a user opens your app. You need to use formulas to
set these values. This tip contains a number of useful such formulas,
including one that selects a date seven days after the current date
as the initial value.
Calcapp was successfully moved to Google Cloud today. Calcapp Creator
was read-only for roughly an hour and Calcapp Connect was fully
offline for three minutes. All services are now fully operational.
We will move Calcapp to Google Cloud on September 30. Running shared
apps should not be impacted by the switch, but you will be unable to
make changes to apps for an hour or more on September 30. The new
servers will make our web site speedier.
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.