🧐 Your opinion needed. Automations in Fibery (limitations and opportunities)

[Chr1sG]

I realise now that I misunderstood this line

@Eva_Folch

When linking entities, it would be great to:

• Filter lookup options dynamically, ex… by Client Name from the current entity.

as meaning that you wanted to apply filtering to the dropdown box of options that appears when linking items, but I guess now it was about ‘creating a lookup collection field with filtering’.

@Eva_Folch

Is this not the same as lookup? Like you say, with a formula, I can also not order the fields, and sorting descending by date is also not possible, right?

No, you’re right, formulas (and lookups) do not behave like ‘normal’ relation views, so if that’s essential, then your options are somewhat limited.
But we do have that in our backlog to address:

Alternatively, your issue would possibly be solved by this:

Automatic linking - increase possibilities beyond "equals"

Is there a specific reason we cannot have auto-link conditions other than “=”? [image] For my use case I would need larger or smaller than comparisons with date fields and regex / “contains” capabilities: If cost center (booking) = cost center (budget category line) Booking date (booking) >= period start (budget category line) Booking date (booking) <= period end (budget category line) Cost element (booking, string) [is within] Concat cost elements (budget category line) Use case simplif…