Spreadsheet formulas usually use position-based references like A2 to refer to
cells while Calcapp formulas use names. Rewriting formulas manually when
you're converting a spreadsheet to an app is tedious and error-prone. This
post explains how you can make Calcapp Creator do the work for you.
Calcapp Creator will soon be much faster when editing large apps. Changing a
field name or caption will be up to 30 times faster and memory usage is
expected to drop to half of what we currently use. We realized these gains by
embracing modern web standards.
By maintaining multiple versions of your app, you can refer back to a prior
incarnation at a later date. It also enables you to share your progress on a
new app version with beta testers, without disturbing the main version used by
your regular users. Learn to duplicate your app to access these features.
Can you convert a spreadsheet with lots of data to a great app with Calcapp
today? Sagger asked us this question and received a reply from our co-founder
David.
Do you have a spreadsheet you'd like to convert to an app? Get in touch with
us and we'd be happy to assess whether Calcapp is a good fit at no charge. If
you need us to do the conversion work, we'll give you an estimate of the work
involved and charge you an hourly fee for our time.
You can use data validation to present an error message alongside an output
number field. Sometimes you want to display the message in the field itself,
though. This blog post shows you two ways to accomplish this.
Is it possible to enter decimal numbers in a Calcapp app on an iPhone? John
posed this question and received a lengthy reply from our co-founder David.
(Short answer: Yes, but it's somewhat awkward, and this issue can't be easily
fixed.)
Making hidden fields visible can be useful when you're developing your app.
Add a "debug mode" switch to your first screen and tie the Visible property of
all hidden fields to this debug switch to easily make all hidden fields
visible. Then, hide the switch before you share the app.
Use formulas to hide and validate fields, make buttons grayed-out, determine
the recipients of reports and more through calculated properties. A video
tutorial introduces the new feature. You can now reference fields from other
panels in formulas by clicking on them. Also, our learning resources have been
thoroughly updated.
In our very first video tutorial, we build a user registration form which
makes heavy use of calculated properties. It is available as a template in
Calcapp Creator for use in your own apps.
Calcapp enables you to create apps that might otherwise have been
created using a spreadsheet. Create apps yourself without
time-consuming and expensive custom software development.