topic Re: Control Chart Alarm Script in Discussions

Control Chart Alarm Script

Ahmed1 — Wed, 11 Oct 2023 14:22:58 GMT

Hi All,

I am trying to customize the alarm scrip email. JMP is sending the sample number. I would like it to send the information from a different column. I have that column marked as a label. How can I add it to the alarm script? Furthermore, Can I send the control chart as in image to multiple emails.

mail( "test@example.com", "Warning ", Substitute( "Out of Control for test ^QCTEST in column ^QCCOL in sample ^QCSAMPLE.",
"^QCTEST", char( qc_test ),
"^QCCOL", qc_col,
"^QCSAMPLE", char( qc_sample ) ));

Thank you in advance.

Re: Control Chart Alarm Script

jthi — Wed, 11 Oct 2023 18:03:38 GMT

Scripting Guide might be helpful for this Run Alarm Scripts. With qc_firstRow and qc_lastRow you should be able to access values in other columns.

Re: Control Chart Alarm Script

Ahmed1 — Fri, 13 Oct 2023 17:37:04 GMT

This does not pull the value of the filename corresponding to the failed sample.

Re: Control Chart Alarm Script

jthi — Fri, 13 Oct 2023 18:18:36 GMT

I have no idea how your data looks like or your chart, so it makes this a bit more difficult. If we assume your column with filename is called "filename" you should be able to access first value for the sample with :filename[qc_firstRow].

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Quality Control/Coating.jmp");
obj = dt << Control Chart(
	Sample Size(:Sample),
	KSigma(3),
	Chart Col(:Weight, XBar, R),
	Alarm Script(
		Write("Out of Control for test ", qc_test, " in column ", qc_col, " in sample ", qc_sample, " marker is ", :Markers[qc_firstRow])
	)
);
obj << Test 1(1);