Validation for the "email address" field in "scheduled email report" table

[Community Alums]

Hi Experts,

Requirement is  email validation .That should any email addresses noted in the "Email addresses" field when scheduling a report to be sent must end in company.com or servicenow.com.

"Email address" field is not a catalog variable. It is a field in the "Scheduled report" table.

any number of email address we can give in that field with separating by comma, all email addresses should get validate . and it is not only for any particular report to schedule. It should be for all.

Help me on achieving this.

Thanks in advance!

[Ankur Bawiskar]

Hi,

you can use normal onChange client script and split the values with comma and then for each value you can check if it's following the standard or not

what's the challenge?

Regards
Ankur

[Community Alums]

Hi @Ankur Bawiskar 

I'm not getting how to validate both mail addresses. Email address must end with either company.com or servicenow.com

Thanks,

[Ankur Bawiskar]

Hi,

example below

it would show you list of invalid email addresses as well

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
	if (isLoading) {
		return;
	}

	var inValidArr = [];
	var isValid = true;
	var arr = newValue.split(',');

	for(var i in arr){
		if(arr[i].toString().endsWith('company.com') || arr[i].toString().endsWith('servicenow.com'))
			isValid = true;
		else{
			isValid = false;
			inValidArr.push(arr[i].toString());
		}
	}

	if(isValid.toString() == 'false' && inValidArr.length > 0){
		alert("Invalid email addresses " + inValidArr.toString());
	}

}

Regards
Ankur

[Ankur Bawiskar]

Hi,

update as this to show error message near field

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
	if (isLoading) {
		return;
	}

	g_form.hideFieldMsg('fieldName');

	var inValidArr = [];
	var isValid = true;
	var arr = newValue.split(',');

	for(var i in arr){
		if(arr[i].toString().endsWith('company.com') || arr[i].toString().endsWith('servicenow.com'))
			isValid = true;
		else{
			isValid = false;
			inValidArr.push(arr[i].toString());
		}
	}

	if(isValid.toString() == 'false' && inValidArr.length > 0){
		g_form.showFieldMsg("fieldName","Invalid email addresses " + inValidArr.toString(),'error', true);
	}

}

Regards
Ankur