sc_link / sc_make_link

Applications Control
#1

Hi,
I had a Control and Field value is fetched from the database, my requirement is to create dynmic link on the Field.

I had refereced sc_link not helping (The documentation says it is for Grid application fields)

I also had refernced sc_make_link also not helping.

anybody suggest me how do i create Link for a Field availble on the Control application (the link varies based on its value or other dependent values)

Thanks in advance

Regards
Dhana

#2

Re: sc_link / sc_make_link

I created a new field of type URL and then populated the field with the URL and it created an ICON to redirect you to that URL.

{myurl_field} = ‘www.myurl.com’;

Did you need something different?

Regards,
Scott.

#3

Re: sc_link / sc_make_link

Scott,
Thanks for you reply,
I want to create a hyperlink from the Field which calls the Other form with parameter. The Form is not static, and refered from the database table based on some conditions. The structure of the forms master is

W010 DC Problem report (PROD) form_dc_pr_master_read v_prno
W014 DC Problem Report (common) form_dc_pr_master_read v_prno
W015 Engg Meeting Review Team form_mom_master_Read v_momcode
W016 Software meeting review form_mom_master_Read v_momcode

Here when the control has W010 and it should have to be Hyperlink, and on clicking the Hyperlink calls the form_dc_pr_master_read with v_prno as parameter, the same way w015 should be called.

basically, the Control is redirecting the Link to several refernce forms with availble value availble in the Control application.

It works fine with Grid application…! But not in Forms or Control applications

Advise

Thanks
Dhana

#4

Re: sc_link / sc_make_link

Perhaps I am just not understanding your requirements.

If you create a control form, that has a TEXT field for ‘W0##’ and a URL field for form_*
You then click on the link field and it loads the required form based on the URL field. (this is your link to dynamic form

Perhaps you could create a link manually in PHP using echo? Sometimes you need to just using PHP and remember you are not limited SC5 macros.

I am not sure if I am over simplifying your problem or I do not understand the the control form objects.

When you mention control, are you referring to an object on a control form, or the control form itself?

I would be willing to look at a sample app if you want to export and email it to me.

Sorry if I am not seeing the picture correctly.

Regards,
Scott.

#5

Re: sc_link / sc_make_link

Scott,

Great…! I had used php direct code href in the Onload, and achived, what i had looking at

$Sql_str= “Select WFM_RefForm,WFM_RefParam,WFM_RefValue from Qry_WF_view1 where WFI_instanceCode=’”.{WF_instance_Code}."’";
sc_lookup(dataset,$Sql_str);

$page={dataset[0][0]};
$parameter={dataset[0][1]};
$pvalue1=(string)"{Reference}";

$string_link = sc_make_link ($page,$parameter=$pvalue1 );

{Reference} = “<a href=’”.$string_link ."’>{Reference}</a>";

Thanks for your help

Regards
Dhana