Reset buttons enable users to conveniently wipe out all data entered in an
app, but pressing them accidentally can ruin days of data entry. This tip
explores a number of techniques for making it harder to press them
accidentally, including hiding them unless the user confirms that they should
You can now use formatted text, including bold, italic and bulleted and
numbered lists. Include links to not just web sites, but also e-mail addresses
and phone numbers. Finally, reports can now be opened directly from apps.
Calcapp now supports inserting links to web addresses, e-mail addresses and
phone numbers. Linking to a phone number enables users on cell phones to place
calls directly from an app. E-mail links cause a user's e-mail client to
appear, with the recipients, subject line and message body you specify.
Calcapp now supports formatted text in text boxes. Use bold, italic, quotes,
links, various headings and bulleted and numbered lists. All features are
keyboard-accessible for a smooth typing experience.
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.