x Want to participate? Join the group to interact
Sage CRM
Related
Recommended

Building Custom Jump Hyperlinks from List blocks

Less than one minute read time.
Setting up a Custom Jump from a list to an ASP page is not difficult as we can see from the image below.



What is not so obvious is how we can cause more than one name/value pair to be included in the QueryString of the hyperlink. In the above example the field oppo_opportunityid is being used. If we want to also include the oppo_primarycompanyid in the hyperlink then we can write in the Custom ID Field

oppo_opportunityid,oppo_primarycompanyid

Note: It must be a comma delimited list.

The same extends to the customization of the lists in ASP pages. The CustomIdField property of the GridColumn Block can be set to a comma delimited list of field names.

var myBlock = eWare.GetBlock("opportunitylist");
var intRecordId = eWare.GetContextInfo("user","user_userid");
var Arg = "oppo_assigneduserid="+intRecordId;
var myGridColBlock = myBlock.GetGridCol("oppo_stage");
with (myGridColBlock)
{
JumpAction= 430;

CustomActionFile = "test.asp";
CustomIdField = "oppo_opportunityid,oppo_assigneduserid";
}
Parents

  • Jeff...if you happen across my previous post on this. I was able to resolve my issue.

    The ASP pages developers course you ran today assisted me in following along to see that my "process" was correct. I appeared to be doing everything right. However, I was not landing on the correct record. Therefore, I went back and looked at my landing page code. I found my issue there.

    My problem was the record id I was passing in the Arg object.

    //Add record object to the screen and Generate the HTML============================

    CRM.AddContent(Container.Execute(TaxRecord));

    Originally I had it defined as..

    var TaxRecord = CRM.FindRecord("USI_RETaxes", "retax_propertyid="+PropertyRecordID+"");

    The tax record is the "many" in a "one to many". I didn't define which record to display (I guess because it was in my URL from the jump..I thought it would magically know..lol). Since the system did not know which Tax Record to display, it just kept picking the first one that belonged to my property.

    My resolution---tell the system which tax record you want:

    Since the tax record ID was in the URL as a result of my CustomJump...I added the following to my landing page..

    var TaxID = Request.QueryString("retax_retaxid");

    AND I redefined TaxRecord as follows:

    var TaxRecord = CRM.FindRecord("USI_RETaxes", "retax_retaxid="+TaxID+"");

    Viola! I am now landing on the correct record.

    Thank you for your assistance!

Comment

  • Jeff...if you happen across my previous post on this. I was able to resolve my issue.

    The ASP pages developers course you ran today assisted me in following along to see that my "process" was correct. I appeared to be doing everything right. However, I was not landing on the correct record. Therefore, I went back and looked at my landing page code. I found my issue there.

    My problem was the record id I was passing in the Arg object.

    //Add record object to the screen and Generate the HTML============================

    CRM.AddContent(Container.Execute(TaxRecord));

    Originally I had it defined as..

    var TaxRecord = CRM.FindRecord("USI_RETaxes", "retax_propertyid="+PropertyRecordID+"");

    The tax record is the "many" in a "one to many". I didn't define which record to display (I guess because it was in my URL from the jump..I thought it would magically know..lol). Since the system did not know which Tax Record to display, it just kept picking the first one that belonged to my property.

    My resolution---tell the system which tax record you want:

    Since the tax record ID was in the URL as a result of my CustomJump...I added the following to my landing page..

    var TaxID = Request.QueryString("retax_retaxid");

    AND I redefined TaxRecord as follows:

    var TaxRecord = CRM.FindRecord("USI_RETaxes", "retax_retaxid="+TaxID+"");

    Viola! I am now landing on the correct record.

    Thank you for your assistance!

Children
No Data
Generic Content
Generic Content

*Community Hub is the new name for Sage City