Take into account not only the first row

[Enigma20xx]

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

[Wim Decorte]

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

[eos]

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

[Enigma20xx]

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