Skip to main content

Hi.  Is it possible to rollup all values of all the links in a field of type link, combined into a larger array? I'll give an example to illustrate better.

I have two tables

  • Reports
    • ExpenseCategoryLinesLinked (Link to ExpenseCategoryLines, many-to-one)
  • ExpenseCategoryLines
    • ReportId (Link to Reports, one-to-many)
    • ExpensesLink (Link to Expenses, many-to-one)
  • Expenses 
    • ExpenseCategoryLineLink (Link to ExpenseCategoryLines, one-to-many)

The idea is to have a Report.AllExpenses as a rollup, which would combine all the Report.ExpenseCategoryLinesLinked > ExpensesLink into one field, as an actual list of links (not text). I've tried using CONCATENATE or ARRAYJOIN, but it returns the IDs as text.

 

Hi @Karl_at_Easy_La ,

I don't know your Base details, so this is just one idea.
If you need to do so, I think you might want to adapt your database structure to that.
Reports -> Expenses ->Expense Category Lines


Also, even with the current database structure, I think it is possible to pseudo-join links by using Automations a lot, but it is hard to support changes and deletions.

Terms & ConditionsAccessibility statement