Create and Manipulate Collection in Formula

Get Help
1

As far as I can see, I am not able to manipulate and output Collections in formulae. They seem to always have to be converted into strings with a Join() function? I would like to calculate connections through a formula rather than an Automation:

So I am modelling my component library in Fibery. It consists of:

  1. Products (e.g. Mobile App, Web App, etc.)
  2. View Templates (e.g. Mobile Base, Mobile Login, etc.), which belong to a Product
  3. Views (e.g. Login, Dashboard, etc.) using a View Template
  4. Components (e.g. Navigation, Listing, List Item) which can be nested

A Component can be placed inside another Component, a View or a View Template. I would like a Component to display in which Products it is used, hence a formula that does kinda the following (pseudocode):

Products = [View Templates].Products + [Views].[View Templates].Products
Products += [Parent Components].Products // Note: yeah, simplified the nesting recursion here
Products.FilterUnique()

Is there any plans adding Collection manipulation in formulae?
Thanks!

Edit: Automation actually cannot solve my problem either.

2

It sounds like you would like a ‘union’ function, for combining collections. It’s not yet possible, but we have the feature in the backlog

3

Thanks @Chr1sG, yes, hadn’t found that thread. Added my comment there.

4

@Chr1sG I’m wondering, is this feature still on the backlog? We’re running an automation to autopromote tasks from the backlog if they were forgotten (unironically this is our use case); tasks that are still in state “Backlog” get a label “Needs Refinement” attached when being promoted. This is where union on collections, or in general adding to a collection comes into play. At the moment our workaround is a script, but given how simple the task actually is I’d prefer using just a Fibery formula.

5

Still in the backlog, but also still no ETA, sorry