To get the number of hours, minutes or seconds between two dates, subtract one
date from the other and use the HOUR, MINUTE or SECOND formula functions.
HOUR won't return a number greater than 23 and MINUTE and SECOND won't return
a number greater than 59. Read on to learn how to fix this.
If you can't run your app because a message asks you to reload the app, don't
press the button. Ignore it for a few minutes and then press OK on the new
message that has appeared.
Have you tried opening a report through an app installed on your iPhone or
iPad home screen, only to be unable to move back to the app? This issue has
now been fixed.
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 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.
Reports can now be opened directly from an app, instead of having them
e-mailed. 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 enables you to create apps that might otherwise have been
created using a spreadsheet. Create apps yourself without
time-consuming and expensive custom software development.