Basic Code Structure of an Edit Page

1 minute read time.
We should now consider the creation of an edit screen for a Record using an ASP page.

The structure is simpler.


var myBlock = eWare.GetBlock('OpportunityDetailBox'); 
var myRecordId = eWare.GetContextInfo('Opportunity','oppo_opportunityid'); 
//var myRecordId = Request.QueryString('oppo_opportunityid'); 
var myRecord = eWare.FindRecord('Opportunity','oppo_opportunityid='+myRecordId); 
eWare.AddContent(myBlock.Execute(myRecord)); 
Response.Write(eWare.GetPage());


The idea to always bear in mind is context. If you are dealing with a standard system entity (e.g. Company, Person, Opportunity etc) then you will be able to use the eWare.GetContextInfo() method to look for the primary key value for the record in context. From this you can then retrieve the record to be edited.

If you are working with a custom entity, perhaps one created using the Advanced Customization Wizard then you will need to get hold of the context information in another way as custom entities can't be accessed using the eWare.GetContextInfo() method.

The context information is held in the Key values of the hyperlink's query string.

The below code shows how to get hold of the correct key value that is contained in the querystring.


var strKeyID= "oppo_opportunityid"; 
var Id = new String(Request.Querystring(strKeyID)); 
var intRecordId = 0; 
if (Id.indexOf(",") > 0) 
{ 
var Idarr = Id.split(","); 
intRecordId = Idarr[0]; 
} 
else if (Id != "") 
{ 
intRecordId = Id; 
}


N.B. In ASP pages that are built using the Advanced Customization Wizard the querystring value that holds the context id value of the custom entity in context is "key58".
Parents
  • Jeff ...

    I updated the page code...but I am still not getting a record returned. Here is the code I am using...I don't get an error...but I don't get a record either. Does this appear to be correct? I can get a record for a list so I know there is a record...just not sure what I am doing wrong...

    var LocContact1Block = CRM.GetBlock('LocContactsDetailBoxC1');

    var AddressID = Request.QueryString("Key58");

    var AddressRecord = CRM.FindRecord("address", "addr_addressid="+AddressID);

    var AddressAlias = AddressRecord.addr_smalias;

    var LocContactRecord = CRM.FindRecord("LOCATIONSITE","ALIAS="+"'AddressAlias'");

    CRM.AddContent(myLocContact1Block.Execute(LocContactRecord));

    Response.Write(CRM.GetPage());

    LOCATIONSITE is my external table name

    ALIAS is the field on the external table I am using to match the data

    Any assistance you can provide would be greatly appreciated....Thank you!

Comment
  • Jeff ...

    I updated the page code...but I am still not getting a record returned. Here is the code I am using...I don't get an error...but I don't get a record either. Does this appear to be correct? I can get a record for a list so I know there is a record...just not sure what I am doing wrong...

    var LocContact1Block = CRM.GetBlock('LocContactsDetailBoxC1');

    var AddressID = Request.QueryString("Key58");

    var AddressRecord = CRM.FindRecord("address", "addr_addressid="+AddressID);

    var AddressAlias = AddressRecord.addr_smalias;

    var LocContactRecord = CRM.FindRecord("LOCATIONSITE","ALIAS="+"'AddressAlias'");

    CRM.AddContent(myLocContact1Block.Execute(LocContactRecord));

    Response.Write(CRM.GetPage());

    LOCATIONSITE is my external table name

    ALIAS is the field on the external table I am using to match the data

    Any assistance you can provide would be greatly appreciated....Thank you!

Children
No Data