Discussions

Expand all | Collapse all

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

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

    Bronze
    Contributor
    Posted 09-19-2017 14:35
    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.


  • 2.  RE: Can I have a formula field maintain the link properties of a relationship?

    Posted 09-19-2017 15:43
    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)


  • 3.  RE: Can I have a formula field maintain the link properties of a relationship?

    Bronze
    Contributor
    Posted 09-19-2017 17:38
    This worked beautifully thank you!