Forum Discussion

AudraMickles's avatar
AudraMickles
Qrew Trainee
2 years ago

Formula URL with Case to open different forms

My goal is this:  when the user clicks the button, it will open a different form depending upon what type of issue the related record in the form has listed.  This is the formula I'm messing with but...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

Try this

URLRoot() & "db/" & Dbid() &
Case([Issue],
"Query Opportunity and Potential Impact","?a=dr&dfid=13",
"Query Review","?a=dr&dfid=12",
"Process Review","?a=dr&dfid=11")
& "&rid=" & [Record ID#]



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------