[Logic] Formulas - Collection Functions - Distinct() or Unique()

Ideas & Features
1

Add a Distinct() or Unique() collection function to formulas to return only unique entities from an entity collection, i.e. *-to-many relation field.

While direct relation fields are already unique, duplicates can appear when using one of Fibery’s strengths: allowing access to fields of the entities in a *-to-many relation field.

With this new formula function, examples below could return unique results with Unique() or Distinct():

  • Contact Related Orgs: For a contact, get all of its relationships’ organisations.
  • Project Task Workers: For a project, get all of its tasks’ assignees.
  • Company Deal Owners: For a company, get all of its deals’ owners.
  • Feature Bug Sprints: For a feature, get all of its bugs’ sprints.
2

For the use cases listed, isn’t this exactly what lookups do already?