Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
When I make Hyperlinks I always make them the same way, no matter how simple or complex.
var text Words = If(
[Related Individual]=null,[Organization Name],
[Individual - Full Name]<>"", [Individual - Full Name]);
var text URL =
IF(
[Related Individual]>0, urlroot() & "db/" & [_DBID_OF_THE_INDIVIDUALS_TABLE] & "?a=dr&rid=" & [Related Individual],
[Related Organization]>0, urlroot() & "db/" & [_DBID_OF_THE_ORGANIZATION_TABLE] & "?a=dr&rid=" & [Related Organization]);
"<a href=" & $URL & ">" & $Words & "</a>"
You will ned to obtain the correct table names from the advanced properties for the table. It's down near the bottom.
var text Words = If(
[Related Individual]=null,[Organization Name],
[Individual - Full Name]<>"", [Individual - Full Name]);
var text URL =
IF(
[Related Individual]>0, urlroot() & "db/" & [_DBID_OF_THE_INDIVIDUALS_TABLE] & "?a=dr&rid=" & [Related Individual],
[Related Organization]>0, urlroot() & "db/" & [_DBID_OF_THE_ORGANIZATION_TABLE] & "?a=dr&rid=" & [Related Organization]);
"<a href=" & $URL & ">" & $Words & "</a>"
You will ned to obtain the correct table names from the advanced properties for the table. It's down near the bottom.