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 be shown.
You can now use formatted text, including bold, italic and bulleted
and numbered lists. Include links to not just websites, but also
email addresses and phone numbers. Finally, reports can now be opened
directly from apps.
Calcapp now supports inserting links to web addresses, email
addresses and phone numbers. Linking to a phone number enables users
on cell phones to place calls directly from an app. Email links cause
a user's email 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.
Reports can now be opened directly from an app, instead of having
them emailed. Use the new feature on its own, or use it as a preview
feature your users can use to check reports before sending them.
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.