Allow Display-only fields to be used in Rule Criteria
On DataPages, Display-only fields are not included in the Rules drop-down for specifying criteria. Caspio currently supports only standard, editable fields in rule criteria. (Note that calculated fields and virtual fields ARE also included in the drop-down list and can be used for rule criteria.)
This is a very restrictive limitation. There are many use cases where one might want to include a Display-only field in the rule criteria. These conditions should NOT be limited to editable fields.
As a work-around, I added a virtual/calculated field and assigned it the value of an existing Display-only field, then wrote my rule using the virtual field. This solved the problem, but the current Caspio restriction should be lifted.
-
Floris commented
A workaround is adding a virtual calculated field that calls the field you want to use in your rule, in its calculation, and hide this virtual field between two html blocks. In the field selection of the rule wizard you'll see the virtual field.