Traffic Light Question

Thu, 22 May 2014 19:38:56 GMT

I have the following information:

Here is what my application shows:

ListBox one contains all the products we have. (Product1,Product2,Product3,etc)

ListBox two contains all the industries we serve. (Industry1, Industry2, Industry3, etc)

Here is what I would like to show.

AcctNumber OrganizationName ProductName Traffic Light

123 Balls Store Product1

123 Balls Store Product2

234 Pales Store Product1 (green light)

345 Young Store Product1

345 Young Store Product2

456 Hall Store Product1 (green light)

Is there a way to do this? The reason I am need this information is they are my upsell opportunities. Any suggestions would be helpful.

David

Re: Traffic Light Question

chematos — Fri, 23 May 2014 18:59:37 GMT

I don't understand what is your problem. Have you created the table? You would need a condition to set the color of the traffic lights.

What is your problem exactly?

maxgro — Fri, 23 May 2014 19:17:20 GMT

if the question is how to make traffic lights, here an example

this is the expression

if(Sum (Expression1)>3000,

'qmem://<bundled>/BuiltIn/led_g.png',

'qmem://<bundled>/BuiltIn/led_r.png'

)