Forum Discussion
Hi Justin,
You could use a rich text formula field to display a button that would take you various forms based on a field value.
Something like this assuming the value is just simple number value:
var text myURLone = URLRoot() & "db/" & [_DBID_JOBS] & "?a=er&dfid=21&rid=" & [Record ID#] //takes you to form id 21 in edit mode
var text myURLtwo = URLRoot() & "db/" & [_DBID_JOBS] & "?a=dr&dfid=14&rid=" & [Record ID#] //takes you to form id 14 in display mode
Case([MY VALUE],
'1', "<a class='Vibrant Success' style='border:1px solid #ffffff; background-color:#f2274c' href="&"\""& $myURLone &"\""&">URL1</a>",
'2', "<a class='Vibrant Success' style='border:1px solid #ffffff; background-color:#f2274c' href="&"\""& $myURLtwo &"\""&">URL2</a>"
)
You can customize what the button looks like for each condition as well. Also note that you can drop them into the form in 'edit' mode or 'display mode'.
------------------------------
Jeff Peterson
------------------------------