Announcement

Collapse
No announcement yet.

sc_link / sc_make_link

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • sc_link / sc_make_link

    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.

    Comment


    • #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




      Comment


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

        Comment


        • #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

          Comment

          Working...
          X