Forum Discussion

PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
3 years ago

Select amongst multiple parent with Click

  • 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
------------------------------
APIs and custom code

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years 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
    ------------------------------
    • PrashantMaheshw's avatar
      PrashantMaheshw
      Qrew Captain
      3 years ago
      Got it ! thanks you Mark for quick reply !

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