Can I have a formula field maintain the link properties of a relationship?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
There are 3 tables, Projects, Claims and Task. One Project has many Task. One Claim has many Task. I would like to see all Task in one report. Currently I have a column for Claims and a column for Projects. Though, if its a Project, the Claim field is always blank, and vice-versa. Is it possible to have a formula to combine them into one field so it shows Claim or Project name depending on which one is still filled in but still maintain its relationship property where if you clicked on it you still are linked you away to the Claim or Project it was associated with. Sorry if this was not clear.
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
So you will need to make you own hyperlink field as a formula text field with HTML enabled.


It will be something like this

var text URLA = URLRoot() & "db/" & [_DBID_BID_CATEGORIES] 
   & "?a=dr&rid=" & [Related Bid Material Category];

var text WordsA = [other table field name like claim name or number];

var text LinkA = "<a href=" & $URLA & ">" & $WordsA & "</a>";


var text URLB = URLRoot() & "db/" & [_DBID_BID_other table name here] 
   & "?a=dr&rid=" & [Related other table ];

var text WordsB = [other table field name like Project name or number];

var text LinkB = "<a href=" & $URLB & ">" & $WordsB & "</a>";

if(
[related claim] > 0, $LinkA,
[related project]  > 0, $LinkB)
Photo of Jordan

Jordan

  • 1,574 Points 1k badge 2x thumb
This worked beautifully thank you!