How to filter a table by related records?

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 !

1 Like

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

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.

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.

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

Cheers, Christiaan

1 Like

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

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).

hi @Joelle_Gaillard , you can use this:

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

Cheers, Christiaan

2 Likes

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.