Lets say:

T1: customers

T2: invoices

 

In the customers layout I have a portal in a popover showing their respcetive invoices (ones paid, others unpaid).

 

What I want to accomplish is (using conditional format for example), to show a tag about the state of the invoices, but only works for the state of the first row.

 

Is it posible to do it for all the rows? I mean, someting like: all paid, none paid, or SOME paid (if there are a few paid but other few not).

 

Thanks for your help.

 

I attach a sample file to show what I'm trying to explain.

DB.zip

You can use the FilterValues() function to test for the occurrence of "paid" or "unpaid" in the related invoices.

Is it posible to do it for all the rows? I mean, someting like: all paid, none paid, or SOME paid (if there are a few paid but other few not).

 

You need to compare the number of paid invoices with the total number of invoices; List() and FilterValues() come in handy here.

 

See attached.

 

PS: Consider using a numerical invoice status; that would make such a calculation even easier.

DB_eosMOD.fmp12.zip

Thanks for your so quick answers, Wim Decorte and eos.

 

I’m not very used to use filter values, but I see I got to learn  .

 

- eos

I have followed your advise and changed to status (numeric format).

 

Nice knowledge gained about merge variables, but I see a “trouble” with them. The variable only updates on registry enter. I think I’ll use the three tag tile.

 

As always, thank you very much

 

PS; Happy New Year to all.

DB_eosMOD_b.zip