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