Make assigned to mandatory when state changes to Closed Complete in List view

[Samiksha2]

Hi All,

I want to make assigned to mandatory when state changes to Closed Complete in List view.

I have created a client script onCellEdit. Field- state

I added the logic if State is Closed Complete and Assigned to or Assignment group is empty then it will not allow to save. 

function onCellEdit(sysIDs, table, oldValues, newValue, callback) {
    var saveAndClose = true;

    var ag = g_form.getValue('assignment_group');
    var as = g_form.getValue('assigned_to');
    if (newValue == 7 && ((ag == '') || (as == '')) {
            alert("Assignment group or Assigned to should not be empty")
            saveAndClose = false;
        } else {
            saveAndClose = true;
        }
        callback(saveAndClose);
    }

It is not working. Please help in this.

Thanks,

Samiksha

[Ankur Bawiskar]

@Samiksha2 

onCell edit can only access value of the field on which onCell edit runs.

So g_form cannot be used there.

For this you need to use before update BR with similar conditions and abort the update

(function executeRule(current, previous /*null when async*/) {

	// Add your code here

	var ag = current.getValue('assignment_group');
	var as = current.getValue('assigned_to');
	if (current.state == 7 && ((ag == '') || (as == ''))) {
		gs.addErrorMessage("Assignment group or Assigned to should not be empty");
		current.setAbortAction(false);
	}

})(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Samiksha2]

Hi @Ankur Bawiskar ,

Thank you for you reply. But it is not working in the List.

Thanks,

Sam

[Ankur Bawiskar]

@Samiksha2 

It should work provided your BR triggers with correct condition

what's the BR trigger condition?

It should be state changes to closed complete

[Samiksha2]

Hi @Ankur Bawiskar ,

Please check the BR condition