Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoThere are part of this code that you can use
var bool Rejected = Case([Record ID# of Current Status Choice],
5, true,
10, true,
24, true
);
//var text GreenLight = "<td width=150 align=center><img src=https://images.quickbase.com/si/32/222-point_green.png>";
//var text LightOff = "<td width=150 align=center><img src=https://images.quickbase.com/si/32/220-point_gray.png>";
//var Text RedLight = "<td width=150 align=center><img src=https://images.quickbase.com/si/32/221-point_red.png>";
var text GreenLight = "<td width=100 align=center> <img src=https://gesco.quickbase.com/up/xxxxxxx/a/r154/e7/v0 width=100 />";
var text LightOff = "<td width=100 align=center> <img src=https://gesco.quickbase.com/up/xxxxxxxx/a/r155/e7/v0 width=100 />";
var Text RedLight = "<td width=100 align=center valign=bottom> <img src=https://gesco.quickbase.com/up/xxxxxxx/a/r156/e7/v0 width=105 />";
// start a table row
"<tr>"
&
// now we have table detail elements with paids of <td> .... </td>
List("  ",
If(
Contains([Request History so far],".01"),
$GreenLight & "<br>Submitted to PM</td>",
If(not $Rejected, $LightOff & "<br>Submitted to PM</td>")),
If(Contains([Request History so far],".02"),
$GreenLight & "<br>PM waiting for Sample / Photo</td>",
If(not $Rejected, $LightOff & "<br>PM waiting for Sample / Photo</td>")),
If(Contains([Request History so far],".03"),
$GreenLight & "<br>PM Reviewing Custom Request</td>",
If(not $Rejected, $LightOff & "<br>PM Reviewing Custom Request</td>")),
If(Contains([Request History so far],".04"),
$GreenLight & "<br>PM Sent Req to Factory</td>",
If(not $Rejected, $LightOff & "<br>PM Sent Req to Factory</td>")),
If(Contains([Request History so far],".05"),
$GreenLight & "<br>PM Recd Factory Response</td>",
If(not $Rejected, $LightOff & "<br>PM Recd Factory Response</td>")),
If(Contains([Request History so far],".06"),
$GreenLight & "<br>PM Sent Response to RSM for Review<td>",
If(not $Rejected, $LightOff & "<br>PM Sent Response to RSM for Review<td>")),
If(Contains([Request History so far],".07"),
$GreenLight & "<br>RSM Approves</td>",
If(not $Rejected, $LightOff & "<br>RSM Approves</td>")),
If(Contains([Request History so far],".08"),
$GreenLight & "<br>PM Reqs Strike-Off Sample</td>",
If(not $Rejected, $LightOff & "<br>PM Reqs Strike-Off Sample</td>")),
If(Contains([Request History so far],".09"),
$GreenLight & "<br>PM Recd Strike-Off<td>",
If(not $Rejected, $LightOff & "<br>PM Recd Strike-Off<td>")),
If(Contains([Request History so far],".10"),
$GreenLight & "<br>Strike-Off Sent to Branch</td>",
If(not $Rejected, $LightOff & "<br>Strike-Off Sent to Branch</td>")),
If(Contains([Request History so far],".11"),
$GreenLight & "<br>PM recd Signed Strike-Off / Acknowledgement<td>",
If(not $Rejected, $LightOff & "<br>PM recd Signed Strike-Off / Acknowledgement<td>")),
If(Contains([Request History so far],".12"),
$GreenLight & "<br>Product Code has been Set Up</td>",
If(not $Rejected, $LightOff & "<br>Product Code has been Set Up</td>")),
If([Record ID# of Current Status Choice]=5,
$RedLight
& "<br> PM Rejected </td>"),
If([Record ID# of Current Status Choice]=10,
$RedLight
& "<br> RSM Rejected </td>"),
If([Record ID# of Current Status Choice]=24,
$RedLight
& "<br> Customer Rejected </td>")
)
& "</tr>"
The effect is to make a a row like this with the image
like this
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var bool Rejected = Case([Record ID# of Current Status Choice],
5, true,
10, true,
24, true
);
//var text GreenLight = "<td width=150 align=center><img src=https://images.quickbase.com/si/32/222-point_green.png>";
//var text LightOff = "<td width=150 align=center><img src=https://images.quickbase.com/si/32/220-point_gray.png>";
//var Text RedLight = "<td width=150 align=center><img src=https://images.quickbase.com/si/32/221-point_red.png>";
var text GreenLight = "<td width=100 align=center> <img src=https://gesco.quickbase.com/up/xxxxxxx/a/r154/e7/v0 width=100 />";
var text LightOff = "<td width=100 align=center> <img src=https://gesco.quickbase.com/up/xxxxxxxx/a/r155/e7/v0 width=100 />";
var Text RedLight = "<td width=100 align=center valign=bottom> <img src=https://gesco.quickbase.com/up/xxxxxxx/a/r156/e7/v0 width=105 />";
// start a table row
"<tr>"
&
// now we have table detail elements with paids of <td> .... </td>
List("  ",
If(
Contains([Request History so far],".01"),
$GreenLight & "<br>Submitted to PM</td>",
If(not $Rejected, $LightOff & "<br>Submitted to PM</td>")),
If(Contains([Request History so far],".02"),
$GreenLight & "<br>PM waiting for Sample / Photo</td>",
If(not $Rejected, $LightOff & "<br>PM waiting for Sample / Photo</td>")),
If(Contains([Request History so far],".03"),
$GreenLight & "<br>PM Reviewing Custom Request</td>",
If(not $Rejected, $LightOff & "<br>PM Reviewing Custom Request</td>")),
If(Contains([Request History so far],".04"),
$GreenLight & "<br>PM Sent Req to Factory</td>",
If(not $Rejected, $LightOff & "<br>PM Sent Req to Factory</td>")),
If(Contains([Request History so far],".05"),
$GreenLight & "<br>PM Recd Factory Response</td>",
If(not $Rejected, $LightOff & "<br>PM Recd Factory Response</td>")),
If(Contains([Request History so far],".06"),
$GreenLight & "<br>PM Sent Response to RSM for Review<td>",
If(not $Rejected, $LightOff & "<br>PM Sent Response to RSM for Review<td>")),
If(Contains([Request History so far],".07"),
$GreenLight & "<br>RSM Approves</td>",
If(not $Rejected, $LightOff & "<br>RSM Approves</td>")),
If(Contains([Request History so far],".08"),
$GreenLight & "<br>PM Reqs Strike-Off Sample</td>",
If(not $Rejected, $LightOff & "<br>PM Reqs Strike-Off Sample</td>")),
If(Contains([Request History so far],".09"),
$GreenLight & "<br>PM Recd Strike-Off<td>",
If(not $Rejected, $LightOff & "<br>PM Recd Strike-Off<td>")),
If(Contains([Request History so far],".10"),
$GreenLight & "<br>Strike-Off Sent to Branch</td>",
If(not $Rejected, $LightOff & "<br>Strike-Off Sent to Branch</td>")),
If(Contains([Request History so far],".11"),
$GreenLight & "<br>PM recd Signed Strike-Off / Acknowledgement<td>",
If(not $Rejected, $LightOff & "<br>PM recd Signed Strike-Off / Acknowledgement<td>")),
If(Contains([Request History so far],".12"),
$GreenLight & "<br>Product Code has been Set Up</td>",
If(not $Rejected, $LightOff & "<br>Product Code has been Set Up</td>")),
If([Record ID# of Current Status Choice]=5,
$RedLight
& "<br> PM Rejected </td>"),
If([Record ID# of Current Status Choice]=10,
$RedLight
& "<br> RSM Rejected </td>"),
If([Record ID# of Current Status Choice]=24,
$RedLight
& "<br> Customer Rejected </td>")
)
& "</tr>"
The effect is to make a a row like this with the image
like this
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- MarkShnier__You5 years ago
Qrew Legend
Here are some of the images we used
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------ - GowthamVemuri15 years agoQrew MemberThankyou for your Quick response Mark. I will give a try and let you know the update.
------------------------------
Gowtham Vemuri
------------------------------