Forum Discussion

KyleChase's avatar
KyleChase
Qrew Trainee
7 years ago

Edit Record on Different Form Based on Field Value

I've got an application up that is managing the process flow for one of 6 products.  When you edit a record, obviously you see the form for the table. However, I need to be able to create 5 more di...
Forms
reports and charts
MattStephens's avatar
MattStephens
Qrew Cadet
4 years ago
Just create a rich text button on your report with coding like this:

var text buttonstuff = "<a class='Vibrant Danger' href='" & URLRoot() & "db/" & Dbid() & "?a=er&rid="& [Record ID#];

Case(  [status],
"1. Draft",
    $buttonstuff & "&dfid=11" & "'>Submit it</a>",
"2. Submitted",
    $buttonstuff & "&dfid=10" & "'>Review it</a>",
"3. Reviewed",
    $buttonstuff & "&dfid=13" & "'>Approve it</a>",
"4. Approved",
    $buttonstuff & "&dfid=14" & "'>Look at it</a>"
)

​

------------------------------
Matt Stephens
------------------------------