Calculated / virtual entities

We use Fibery as a nonprofit fundraising CRM: there are a bunch of domain-specific entities (people, orgs, grant applications, donations etc.) and Tasks associated with them.

Currently Tasks have to be created manually. However, depending on an entity’s state, sometimes, there must always be a task. For example:

  • If a donation is in “pledged” state, there must always be a task to collect it. Once it changes to a “paid” state, there must be a task to thank the donor. After that, there must be no task.
  • If a prospect is in “finding introduction” state, there must always be a task to find a warm intro to them.
  • Etc.

I could see this being structured as having a prospect’s or a donation’s “Tasks” be a calculated field that is recalculated upon changes to some of its fields. This is not impossible (for an engineer) to do via scripting automations, but I imagine there could be big possibilities if we had this as a first-class feature, allowing formulas to return entities or lists of entities, including new entities.

This should be fairly easy to achieve using automations without needing any scripting.
No need for coding :blush: