I've done this before successfully, so I am not sure what my error is. I am making a clickable link (Rich Text Field) and using that field in a report link. It typically works fine, but this time when I click on the link, it is simultaneously opening the record (as it would if you typically clicked along the record entry). What is my error that is causing this?
var text AmountText = "$" & ToFormattedText([Vendor Subcontract - Total Amount from Invoiced Projects],"comma_dot");
var number Amount = [Vendor Subcontract - Total Amount from Invoiced Projects];
var number Subcontract = [Vendor Subcontract - Total With Mods];
var text URL = URLRoot() & "db/" & "brgx8j65y?a=dr&dfid=11&rid=" & [Record ID#];
If(
$Amount<$Subcontract, $AmountText,
$Amount>$Subcontract,
"<a class='OpenAsPopup' data-height=500 data-width=700 span style=\"background: Yellow; color: Red; text-align: center; font-size: 12px \"href='"
& $URL
& "'><b>" & $AmountText & " (Click for Details)</span></a>")
------------------------------
Mike Tamoush
------------------------------
Question
Clickable Link In Report Link
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.