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