Forum Discussion

GowthamVemuri1's avatar
GowthamVemuri1
Qrew Member
4 years ago

How to create a flow representation

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

3 Replies

  • 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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Qrew Champion
      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
      ------------------------------
    • GowthamVemuri1's avatar
      GowthamVemuri1
      Qrew Member
      Thankyou for your Quick response Mark. I will give a try and let you know the update.

      ------------------------------
      Gowtham Vemuri
      ------------------------------