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.