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.