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 ...

APIs and custom code

MarkShnier__You

Qrew Legend

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

Qrew Captain

3 years ago

Got it ! thanks you Mark for quick reply !

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

Forum Discussion

Select amongst multiple parent with Click