The new CHOOSE function can be used as a compact, fast alternative to IF in
some situations. Use it together with the Index property of drop-down fields
to quickly return data matching a value selected by your user.
The new Index property of drop-down fields returns the numeric position of the
selected value and the Size property returns the number of values. Index is
designed to work well with the new CHOOSE formula function.
Troy reported getting error messsages from Calcapp Creator when editing a
large app. While his issue appears to have disappeared, Calcapp sometimes does
have issues with very large apps. Our co-founder David discusses our future
plans for solving this issue in his reply.
Can Calcapp be considered a programming language today? How will it evolve in
the future? Will it stay true to its spreadsheet roots or will it look more
like traditional programming? Bob posed these questions and received a
technical reply from David, our co-founder.
Create apps in one of our 79 supported languages, with correct formatting of
numbers, dates and times. Make apps bigger or smaller with the new zoom level
feature. Use eight new language-savvy functions to format values from
formulas. Finally, you can now use formulas to determine labels of fields and
Calcapp now supports 79 languages and 147 language variants, enabling numbers,
dates and times to be formatted correctly. We have translations for app text
provided by Calcapp in 30 languages. Five languages have been translated by
human translators and the rest using machine-translation.
Use the new zoom level feature to make apps appear larger or smaller.
Associate a formula with the zoom level property to give your users control
over the size with, say, a slider or a switch field. Be sure to make these
fields persistent so the zoom level is remembered.
Our new sample app is a calculator for shared household expenses. It enables
users to define recurring expenses in one panel and fields for those expenses
are then created in another panel. This app demonstrates formula-driven
New properties enable you to set validation messages, field units and labels
of groups, fields, buttons and list panel options through formulas. This
feature enables your apps to more closely adapt to values entered by your
Use four new functions to turn numbers into formatted text strings. Another
four functions convert numbers stored in text strings to pure numbers. All new
functions take the app language into account and support 147 language