Table Scripting - Revision history

Crmtogetherkb at 19:21, 18 July 2016

2016-07-18T19:21:54Z

← Older revision		Revision as of 20:21, 18 July 2016
Line 102:		Line 102:

	----		----

			PostInsertRecord

			https://community.sagecrm.com/user_community/f/84/t/10447.aspx

Crmtogetherkb at 15:48, 2 May 2014

2014-05-02T15:48:24Z

← Older revision		Revision as of 16:48, 2 May 2014
Line 102:		Line 102:

	----		----




	~~function Ajax() {~~
	~~try {~~
	~~if(window.XMLHttpRequest) {~~
	~~return new XMLHttpRequest();~~
	~~} else if(window.ActiveXObject) {~~
	~~try {~~
	~~return new ActiveXObject('Msxml2.XMLHTTP');~~
	~~} catch(try_again) {~~
	~~return new ActiveXObject('Microsoft.XMLHTTP');~~
	}
	}
	~~} catch(fail) {~~
	~~return null;~~
	}
	}

	~~function sendMail(to, subject) {~~
	~~var rq;~~
	~~if(rq = new Ajax()) {~~
	~~// Success; attempt to use an Ajax request to a PHP script to send the e-mail~~
	~~try {~~
	~~rq.open('GET', 'sendmail.php?to=' + encodeURIComponent(to) + '&subject=' + encodeURIComponent(subject) + '&d=' + new Date().getTime().toString(), true);~~
	~~rq.onreadystatechange = function() {~~
	~~if(this.readyState === 4) {~~
	~~if(this.status < 200 \|\| this.status >= 400) {~~
	~~// The request failed; fall back to e-mail client~~
	~~window.open('mailto:' + to + '?subject=' + encodeURIComponent(subject));~~
	}
	}
	}
	~~rq.send(null);~~
	~~} catch(fail) {~~
	~~// Failed to open the request; fall back to e-mail client~~
	~~window.open('mailto:' + to + '?subject=' + encodeURIComponent(subject));~~
	}
	~~} else {~~
	~~// Failed to create the request; fall back to e-mail client~~
	~~window.open('mailto:' + to + '?subject=' + encodeURIComponent(subject));~~
	}
	}




	~~====~~
	~~set config = CreateObject("CDO.Configuration")~~
	~~sch = "http://schemas.microsoft.com/cdo/configuration/"~~
	~~with config.Fields~~
	~~.item(sch & "sendusing") = 2 ' cdoSendUsingPort~~
	~~.item(sch & "smtpserver") = application("smtpserver")~~
	~~.item(sch & "smtpserverport") = application("smtpserverport")~~
	~~.item(sch & "smtpauthenticate") = 1 'basic auth~~
	~~.item(sch & "sendusername") = application("sendusername")~~
	~~.item(sch & "sendpassword") = application("sendpassword")~~
	~~.update~~
	~~end with~~

	~~with CreateObject("CDO.Message")~~
	~~.configuration = config~~
	~~.to = ...~~
	~~.from = ...~~
	~~.subject = ....~~
	~~.HTMLBody = ....~~
	~~call .send()~~
	~~end with~~

Crmtogetherkb at 12:01, 2 May 2014

2014-05-02T12:01:57Z

← Older revision		Revision as of 13:01, 2 May 2014
Line 102:		Line 102:

	----		----




			function Ajax() {
			try {
			if(window.XMLHttpRequest) {
			return new XMLHttpRequest();
			} else if(window.ActiveXObject) {
			try {
			return new ActiveXObject('Msxml2.XMLHTTP');
			} catch(try_again) {
			return new ActiveXObject('Microsoft.XMLHTTP');
			}
			}
			} catch(fail) {
			return null;
			}
			}

			function sendMail(to, subject) {
			var rq;
			if(rq = new Ajax()) {
			// Success; attempt to use an Ajax request to a PHP script to send the e-mail
			try {
			rq.open('GET', 'sendmail.php?to=' + encodeURIComponent(to) + '&subject=' + encodeURIComponent(subject) + '&d=' + new Date().getTime().toString(), true);
			rq.onreadystatechange = function() {
			if(this.readyState === 4) {
			if(this.status < 200 \|\| this.status >= 400) {
			// The request failed; fall back to e-mail client
			window.open('mailto:' + to + '?subject=' + encodeURIComponent(subject));
			}
			}
			}
			rq.send(null);
			} catch(fail) {
			// Failed to open the request; fall back to e-mail client
			window.open('mailto:' + to + '?subject=' + encodeURIComponent(subject));
			}
			} else {
			// Failed to create the request; fall back to e-mail client
			window.open('mailto:' + to + '?subject=' + encodeURIComponent(subject));
			}
			}




			====
			set config = CreateObject("CDO.Configuration")
			sch = "http://schemas.microsoft.com/cdo/configuration/"
			with config.Fields
			.item(sch & "sendusing") = 2 ' cdoSendUsingPort
			.item(sch & "smtpserver") = application("smtpserver")
			.item(sch & "smtpserverport") = application("smtpserverport")
			.item(sch & "smtpauthenticate") = 1 'basic auth
			.item(sch & "sendusername") = application("sendusername")
			.item(sch & "sendpassword") = application("sendpassword")
			.update
			end with

			with CreateObject("CDO.Message")
			.configuration = config
			.to = ...
			.from = ...
			.subject = ....
			.HTMLBody = ....
			call .send()
			end with

Crmtogetherkb at 12:00, 2 May 2014

2014-05-02T12:00:09Z

← Older revision		Revision as of 13:00, 2 May 2014
Line 102:		Line 102:

	----		----

	~~Sending emails~~

	~~Ref: https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2009/03/13/sending-emails-in-asp-com-api.aspx~~


	~~Using CDONTS~~

	~~var MyCDONTSMail = CreateObject("CDONTS.NewMail");~~
	~~MyCDONTSMail.From= "somebody@nowhere.com";~~
	~~MyCDONTSMail.To= "nobody@nowhere.com";~~
	~~MyCDONTSMail.Subject="This is a Test";~~
	~~MyBody = "Thank you for ordering that stuff";~~
	~~MyCDONTSMail.Body= MyBody;~~
	~~MyCDONTSMail.Send();~~

Crmtogetherkb at 11:55, 2 May 2014

2014-05-02T11:55:46Z

← Older revision		Revision as of 12:55, 2 May 2014
Line 99:		Line 99:
	XmlHttp=null; // always clear the XmlHttp object when you are done to avoid memory leaks		XmlHttp=null; // always clear the XmlHttp object when you are done to avoid memory leaks
	}		}


			----

			Sending emails

			Ref: https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2009/03/13/sending-emails-in-asp-com-api.aspx


			Using CDONTS

			var MyCDONTSMail = CreateObject("CDONTS.NewMail");
			MyCDONTSMail.From= "somebody@nowhere.com";
			MyCDONTSMail.To= "nobody@nowhere.com";
			MyCDONTSMail.Subject="This is a Test";
			MyBody = "Thank you for ordering that stuff";
			MyCDONTSMail.Body= MyBody;
			MyCDONTSMail.Send();

Crmtogetherkb at 11:08, 14 February 2014

2014-02-14T11:08:00Z

← Older revision		Revision as of 12:08, 14 February 2014
Line 63:		Line 63:

	Ref: https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2011/08/19/how-do-you-know-if-your-table-level-scripts-are-being-executed.aspx		Ref: https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2011/08/19/how-do-you-know-if-your-table-level-scripts-are-being-executed.aspx


			----

			Function to get the SID from within a table level script - you may want to do this to call an asp page via ajax for example

			Based off of code at: https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2008/03/25/how-can-i-get-the-sid-in-serverside-scripting.aspx

			function getsid()
			{
			var strPath = new String(CRM.URL(200));
			var arrayFullKeys = strPath.split("?");
			var arrayKeys = arrayFullKeys[1].split("&");
			for (var i=0;i<arrayKeys.length;i++)
			{
			var arrayValue = arrayKeys[i].split("=");
			if (arrayValue[0].toLowerCase()== "sid")
			{
			return arrayValue[1];
			}
			}
			return "";
			}


			----

			To Make an Ajax GET request call from within a table script

			function MakeAjaxPostRequest(RequestPath)
			{
			var XmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
			XmlHttp.open('GET',RequestPath,false);
			XmlHttp.send();
			XmlHttp=null; // always clear the XmlHttp object when you are done to avoid memory leaks
			}

Crmtogetherkb at 15:14, 15 May 2013

2013-05-15T15:14:43Z

← Older revision		Revision as of 16:14, 15 May 2013
Line 57:		Line 57:

	function log(message, error) {try{CRM.CreateQueryObj('/* '+((error)?message:message+' */')).SelectSql();}catch(e){}}		function log(message, error) {try{CRM.CreateQueryObj('/* '+((error)?message:message+' */')).SelectSql();}catch(e){}}

	function InsertRecord() { log("InsertRecord called",1); }		function InsertRecord() { log("InsertRecord called",1); }

	function PostInsertRecord() { log("PostInsertRecord called",1); }		function PostInsertRecord() { log("PostInsertRecord called",1); }

	function UpdateRecord() { log("UpdateRecord called. WHERECLAUSE=" + WHERECLAUSE,1); }		function UpdateRecord() { log("UpdateRecord called. WHERECLAUSE=" + WHERECLAUSE,1); }

	function DeleteRecord() { log("DeleteRecord called. WHERECLAUSE=" + WHERECLAUSE,1); }		function DeleteRecord() { log("DeleteRecord called. WHERECLAUSE=" + WHERECLAUSE,1); }

	Ref: https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2011/08/19/how-do-you-know-if-your-table-level-scripts-are-being-executed.aspx		Ref: https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2011/08/19/how-do-you-know-if-your-table-level-scripts-are-being-executed.aspx

Crmtogetherkb at 15:14, 15 May 2013

2013-05-15T15:14:25Z

← Older revision		Revision as of 16:14, 15 May 2013
Line 54:		Line 54:
	Useful learning tool if your trying to work out when each of the TLS functions are called.		Useful learning tool if your trying to work out when each of the TLS functions are called.

	// Table level script will log all events to the SQL logs		Table level script will log all events to the SQL logs

	function log(message, error) {try{CRM.CreateQueryObj('/* '+((error)?message:message+' */')).SelectSql();}catch(e){}}		function log(message, error) {try{CRM.CreateQueryObj('/* '+((error)?message:message+' */')).SelectSql();}catch(e){}}

	function InsertRecord() { log("InsertRecord called",1); }		function InsertRecord() { log("InsertRecord called",1); }

	function PostInsertRecord() { log("PostInsertRecord called",1); }		function PostInsertRecord() { log("PostInsertRecord called",1); }

	function UpdateRecord() { log("UpdateRecord called. WHERECLAUSE=" + WHERECLAUSE,1); }		function UpdateRecord() { log("UpdateRecord called. WHERECLAUSE=" + WHERECLAUSE,1); }

	function DeleteRecord() { log("DeleteRecord called. WHERECLAUSE=" + WHERECLAUSE,1); }		function DeleteRecord() { log("DeleteRecord called. WHERECLAUSE=" + WHERECLAUSE,1); }

	Ref: https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2011/08/19/how-do-you-know-if-your-table-level-scripts-are-being-executed.aspx		Ref: https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2011/08/19/how-do-you-know-if-your-table-level-scripts-are-being-executed.aspx

Crmtogetherkb at 15:14, 15 May 2013

2013-05-15T15:14:00Z

← Older revision		Revision as of 16:14, 15 May 2013
Line 48:		Line 48:

	if (c_comp_renewaldate.getDate() != v_comp_renewaldate.getDate())...		if (c_comp_renewaldate.getDate() != v_comp_renewaldate.getDate())...


			----

			Useful learning tool if your trying to work out when each of the TLS functions are called.

			// Table level script will log all events to the SQL logs

			function log(message, error) {try{CRM.CreateQueryObj('/* '+((error)?message:message+' */')).SelectSql();}catch(e){}}

			function InsertRecord() { log("InsertRecord called",1); }

			function PostInsertRecord() { log("PostInsertRecord called",1); }

			function UpdateRecord() { log("UpdateRecord called. WHERECLAUSE=" + WHERECLAUSE,1); }

			function DeleteRecord() { log("DeleteRecord called. WHERECLAUSE=" + WHERECLAUSE,1); }

			Ref: https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2011/08/19/how-do-you-know-if-your-table-level-scripts-are-being-executed.aspx

Crmtogetherkb at 10:29, 8 February 2013

2013-02-08T10:29:41Z

← Older revision		Revision as of 11:29, 8 February 2013
Line 29:		Line 29:
	----		----

	Comparing previous values		Comparing previous values (in cases where you might want to run some code only when a field value has changed)

	Within the UpdateRecord method stub you would first query the current record using		Within the UpdateRecord method stub you would first query the current record using