CHANGELOG: October 1 / Create Documents and Whiteboards inside entities, Automatically link entities based on rules

[Chr1sG]

Yes, we can, but at the moment, formulas (and lookups and auto-relations) are ‘read-only’, whereas the bit you quoted was more about a semi-deterministic relationship.

I am optimistic that Fibery will eventually support more complexity in relations, like filtered selection:

[APPROVED] Relationships filter

It would be great to be able to create a Relation column that only shows a filtered subset of the relevant Type. So for example, a relation column that only shows Tasks that are already marked “done,” or Expenses that are greater than $100. Etc.

or more sophistication in formulas, so that they are not necessarily read-only, which is touched upon here:

Inheritance of Relation

For what it’s worth, the Binders app I have used a fair bit deals with this in the following way: You define a calculation for a field (formula type thing) and you choose one of four behaviours: Calculated and stored (i.e. default value) Calculated on demand (you click a button to ‘run’ the calculation Calculated else entered (as long as the calculation yields a valid result, this overrides any user choice) Entered else calculated (as long as the user has made a valid choice, this overrides t…