Tip: Easily copy and paste fields between apps
When copying and pasting fields and screens from one app to
another, it really helps if both are displayed side-by-side. This
tip explores how to achive this.
The Calcapp blog
Tips, new features, sample apps and letters from the team.
Tip: Decide which image to show with a formula
Conveying a calculated result by showing a specific image in your
app can help improve its usability. This concise tip explores this
simple technique.
Our next release has been delayed
Our next release has been slightly delayed, because we are adding
new features to it. Two of those features are announced in this
post, including a better formula editing experience and an easy way
to check multiple items in Calcapp Creator.
Tip: Use iteration with REDUCE
Iteration means that a value is calculated by performing a number
of steps, where the result of the previous step is fed into the
current step. Use REDUCE to implement iteration with Calcapp.
Action formulas and a tabular data editor are coming soon
Calcapp will become significantly better in the coming months.
Action formulas will enable buttons to run formulas, and a new data
editor will allow you to easily incorporate spreadsheet data into
your apps.
Tip: Summarize switch field selections in a single sentence
Can the switch field selections made by a user be summed up in a
single text field sentence? Yes, and there are two ways to do it,
one using old-style formulas and one using the new formula engine
we introduced in November.
Tip: Display all US legal holidays for a given year
In this post, we create an app that displays all legal US holidays
for a given year. The app adapts a formula created for Microsoft
Excel and uses new functions introduced with our new formula
engine, like FORMATDATE, FILTER and TEXTJOIN.
Tip: Custom formatting of dates
When formatting dates, you can choose from five pre-defined date
formats. What if you want a custom date format? For output fields,
you can use text fields and formulas to achieve this. This post
explores two formula approaches.
Tip: Add separators to reports
Add separators between fields — essentially, line breaks — anywhere
you like in your reports by following the steps of this tip.
Release: Our November, 2021 update is here
Our biggest release ever is here, celebrated with 23 blog posts.
Use 100+ new functions, including XLOOKUP and SUMIFS. Determine the
next screen and what fields are included in a report using
formulas. Several thousand formula examples help you get started
with all the new features.