Skip to main content
Question

How to create a flow representation

  • September 3, 2020
  • 0 replies
  • 45 views

Hi All

I would like to create this kind of process flow for my client and its my volunteer decision to make the application user friendly. 
I have a field "Status", starting from Not Started to Completed. I want to implement this, but ended up with question...How !

Any help is greatly appreciated.

Thanks in advance.
Regards
Gowtham


------------------------------
Gowtham Vemuri
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
There 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("&nbsp&nbsp",

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
------------------------------