Use a Group of Approvers in a Workflow Utilizing a Workflow Action Script

Jcurve Support Articles / Setup & Customisation

Use a Group of Approvers in a Workflow Utilizing a Workflow Action Script

Written by
Manuelito Macalinao

Published on
August 31st, 2023

Scenario

User needs toincorporatea certain group ofApprovers,SupervisorsorEmployeesto aWorkflowto handle the approval process ofa record.

Solution

1. Create aWorkflowactionscriptthat would check if the current user is a member of the Group of Approvers by navigating toCustomization>Scripting>Scripts>New. The logic will make use of an Entity Group search checking, if the user's internal ID belongs to the group. You also need to define aReturn Type(Free-Form Text) on the createdWorkflowaction script. Use the script below:

functioncheckUserIfMember(){var user =nlapiGetUser(); filters =newArray(), columns =newArray(), searchresults =newArray(); filters[0]=newnlobjSearchFilter('internalid',null,'is',14703);//internal id of the static Group filters[1]=newnlobjSearchFilter('internalid','groupmember','is', user); columns[0]=newnlobjSearchColumn('internalid','groupmember');// Member Idtry{// Check for user searchresults =nlapiSearchRecord('entitygroup',null, filters, columns);// Return true if we have resultsif(searchresults){return'T';}}catch(e){nlapiLogExecution('DEBUG', e.name, e.message);return'F';}return'F';}

2. Create aStatewhere you want to initiate the customAction Script. Preferrably the initialStateon theWorkflow.
3. On the createdState, add a stateFieldthat would hold the returned value of the customScriptin Step 2. The returned value will be used as condition on the subsequent actions and conditions on theWorkflow.

Note:

Alternatively, the same logic can also be implemented using SuiteScript 2.0.

/** * @NApiVersion 2.x * @NScriptType workflowactionscript */define(['N/runtime','N/search'],function(runtime, search){functiononAction(scriptContext){var userObj = runtime.getCurrentUser();var user = userObj.id;var entitygroupSearchObj = search.create({ type:"entitygroup", filters:[["internalid","anyof","14703"],//internal id of the static Group"AND",["groupmember.internalid","anyof", user]], columns:[ search.createColumn({ name:"groupname", sort: search.Sort.ASC, label:"Name"})]});try{// Check for uservar searchresults = entitygroupSearchObj.runPaged().count;// Return true if we have resultsif(searchresults){return'T';}}catch(e){ log.debug(e.name, e.message);return'F';}return'F';}return{ onAction : onAction };});

Jcurve Support Articles / Setup & Customisation