Jump to content

Take into account not only the first row


Enigma20xx
 Share

This topic is 2890 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 :hmm: .

 

- 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

Link to comment
Share on other sites

This topic is 2890 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.