Forum Discussion

JordanBeatty1's avatar
JordanBeatty1
Qrew Captain
8 years ago

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

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.
Ask about Quickbase functionality
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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)