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.
Our new data editor allows you to easily create and edit
spreadsheet-like data tables. Data can be imported from spreadsheets
through copy and paste. Use XLOOKUP to look up values in data tables.
We are introducing a new set of plans at higher price points.
Existing apps stay on the old plans at the old prices, with access to
most of our new features. The new button types, the data editor,
named values and action formulas require you to upgrade to a 2023
plan.
Our new formula autocomplete system provides helpful suggestions for
what you may want to type next. To reference a field on any screen,
just type part of its name or label and let us do the rest.