How to filter a table by related records?

1

Hi

Newbie here and I need your help to filter a table based on related records.
Here is my coda page. Thx for your help !

2

hi @Joelle_Gaillard , not sure if you look for this:

Invoices.Filter(Orders.Contains(thisRow))

see the column ‘like this’. hope it helps.

Cheers, Christiaan

3

No, I don’t think that’s what I’m trying to do. In the table List of orders, I would like to filter the rows with the selector.

4

Salut @Joelle_Gaillard ,

I did not read carefully, below what could help. I created a column with the invoices using the mentioned formula and in the Table Filter I reference this one and link it to the controller you created. I had to add ToText() to make it work.

image
image2963×1462 197 KB

you can skip this column invoice and directly use this in the table filter, but for testing this was practical.

Cheers, Christiaan

5

Yes ! That’s it ! Thank you a lot. I was missing the .ToText() in my tests.

6

One more question. I can’t figure out how to set this filter without using the invoices column in the table list of orders.

The problem is that I can’t get the two records from the invoice 2 (table invoices).

CleanShot 2022-03-21 at 16.15.11@2x
CleanShot 2022-03-21 at 16.15.11@2x2166×1072 203 KB

7

hi @Joelle_Gaillard , you can use this:

Invoices.Filter(Orders.Contains(thisRow)).[invoice id - selector] =choixFacture

image
image1505×755 50.7 KB

Cheers, Christiaan

8

Yes !
thanks a lot !
your help is very valuable !