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.
You can now reference fields from other panels by clicking on them when you're
editing a formula. You can also reference buttons and the other items that
make up an app from your formulas by clicking on them.
Fields, buttons, calculation panel groups, text boxes, list panel options and
panels now offer a variety of calculated properties you can use to make your
apps more dynamic. This post offers the complete list.
Use formulas to hide and validate fields, make buttons grayed-out, determine
the recipients of reports and more through calculated properties. These
formulas are evaluated when your app is run and make it possible to build far
more dynamic, complex apps.
Will Calcapp ever support importing your spreadsheets directly? Allan posed
this question to us and received a lengthy reply from our co-founder David.
This update brings cross-references, enabling you to build large,
interconnected apps. Flag suspicious values with data validation and send
reports as PDF files.
Use cross-references to refer to other panels with our next release, enabling
you to build truly large, inter-connected apps. This update also lays the
groundwork for calculated properties, which are coming soon.
Use data validation to flag invalid values with our next release. Specify
allowable intervals for number fields to determine validity. A later release
will allow you to use formulas to determine if a field is valid or not.
Customize the sender of reports that are e-mailed from your apps with our next
release. Soon, you will also be able to determine the sender using a formula.
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.