Discussions

Expand all | Collapse all

Select amongst multiple parent with Click

  • 1.  Select amongst multiple parent with Click

    Posted 10 days ago
    • I've a children table "Task" whose parent is from table A-"Senior Staff Project" or table B-"Junior Staff Project"
    • In child table "task" , a very simple Rich Text say "P.name" formula determines the parent child with
      • if[related senior staff project>0,"Related Staff Project", "Junior Staff Project")
    • But "rich text" formula "p.name" is not clickable , nor does it related to the original project 
    • How can I achieve so ? 


    ------------------------------
    Prashant Maheshwari
    ------------------------------


  • 2.  RE: Select amongst multiple parent with Click

    Posted 10 days ago
    You will need to build you own Rich text hyperlink field

    The generic format is 

    Hyperlink Example

    var text Words = ....;

    var text URL = URLRoot() & "db/" & [_DBID_PATIENTS] & "?a=dr&rid=" & [Related Patient];


    // this last part is always the same

    "<a href=" & $URL & ">" & $Words & "</a>"

    so for the words you will have an IF statement to calculate the correct name.


    Then, similarly you calculate the correct URL to go to.  You can post back if you have trouble calculating the URL syntax. 

      


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Select amongst multiple parent with Click

    Posted 10 days ago
    Got it ! thanks you Mark for quick reply !

    ------------------------------
    Prashant Maheshwari
    ------------------------------