You can now import spreadsheet data and use it with drop-down fields.
Watch our video tutorial to learn how to use the new feature. Also,
customize the loading screen and use powerful new formula functions
to process text. Finally, new color themes make it a snap to
experiment with app colors.
Import spreadsheet data directly for use with drop-down fields. Paste
the data from your table into our app to automatically generate
Calcapp formulas.
Values of drop-down fields can now be edited as text. This feature
makes it possible to paste values from a spreadsheet all at once. It
also enables more efficient keyboard editing.
Our latest sample app converts spreadsheet column data to formulas
for use with drop-down fields. This app uses regular expressions
heavily and this post explains in detail how it was built.
You can now customize the loading screen, also known as the splash
screen. Change the colors or hide the logo, the progress indicator or
both. You can also fully disable the loading screen, which is useful
for apps embedded in websites.
You can now set base colors for your entire app through the start
screen. These colors affect not just your panels but also the loading
screen. We have also added a theme selector with five pre-defined
color themes to allow you to more easily experiment with colors.
Calcapp now supports three new text-processing functions, enabling
you to determine if text matches a certain pattern and to extract and
replace text, also using patterns. The three functions use so-called
regular expressions.
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.