If you have an app for a large product catalog, with screens for
every product, having a large list screen leading to all products may
not be practical. This tip explores an alternative.
Named values can reference anything in an app and are a great way to
cut down on formula repetition. They now work properly even when
pushed to the maximum. We have fixed other issues as well.
Calculating the number of days, months or years between two dates can
be done with DATEDIF in Excel, or using plain formulas in Calcapp.
These formulas are explored in this tip.
Apps can store invisible information when a button is pressed, which
is retained even when the app is closed. Our sample app uses this
technique to enforce that a button is only pressed once per day.
Our most significant release yet is here, with 23 blog posts to
describe it all. Build previously-unthinkable apps with action
formulas. Import and edit spreadsheet-like data and use eleven new
button types. The app designer now supports undo, formula
autocomplete, a new email editor and much more.
Eleven new types of buttons make your apps easier to use and more
powerful. Buttons can run action formulas, change the active screen,
copy text to the clipboard, show messages and more.
Action formulas make things happen, unlike regular functions, which
calculate values. They are our biggest new feature yet. Use them to
model complex business logic.