Help using filter and getting two results

1

Morning all

I’m using filter in a formula and I would like to get 2 results rather than just one.

For example:

[Board Materials].Filter(thisRow.Service=“Manufacture” AND thisRow.[Job Type].Contains(Range) AND thisRow.[Material Brand].Contains(Brand)).[Width (mm)] ,

That will give me the result of the ‘Width (mm)’ column.

I would like to get the results from ‘Length (mm)’ and Width (mm) columns.

I tried using using something like this:

[Board Materials].Filter(thisRow.Service="Manufacture" AND thisRow.[Job Type].Contains(Range) AND thisRow.[Material Brand].Contains(Brand)).Concatenate("mm x ", [Board Materials].Filter(thisRow.Service="Manufacture" AND thisRow.[Job Type].Contains(Range) AND thisRow.[Material Brand].Contains(Brand)).[Length (mm)], "mm"),

Although that works, it doesn’t work if the column has values separated with a comma.

2

Hi @Juanmata,

In this case I would create one column with the formula to extract the “width” and another column to extract the “lenght” and in one column with concatenate to combine the values in the format you wish.

Maybe not the most elegant solution, but the result will be there.
Does this make sense :grinning:

3

@Jean_Pierre_Traets

That does make sense but I was trying to stay clear of having extra columns for silly things like that,

4

Adding logic in hidden columns is a core implementation mechanism in Coda - they’re almost like real-time function calls that operate on each row whenever something changes. They’re incredibly powerful.

Take a look at this truly excellent Work Breakdown Structure project for example. See how many hidden columns there are and how they’re used…

2 Likes