Create second task based on First task closure for user A - workflow

[Ankita9793]

Hi All,
I have a requirement where multiple tasks gets created through run script for each MRVS row.
Whenever a user’s 1st task/Genesys task is completed, SNOW must automatically create a new task for Media Recording team for that same user. This should happen for every user in the request in the sequence of his task closure. Please suggest. 

Example – Users – A, B, C

Genesys task created –

• SCTASK001 – User A – Genesys
• SCTASK002 – User B – Genesys
• SCTASK003 – User C – Genesys

When Genesys completes for User B first:

• SCTASK002 Closed – Create SCTASK004 (User B – Media Task)

When Genesys completes User A later:

• SCTASK001 Closed - Create SCTASK005 (User A – Media Task)

When Genesys completes User C last:

• SCTASK003 Closed Incomplete - No Media task to be created

RUN Script : 

var rec = new GlideRecord('sc_task');

rec.addQuery('request_item', current.getUniqueValue());

rec.addQuery('state', '3');

rec.addQuery('active', 'false');

rec.query();

if (rec.next()) {

    gs.print('rec.short_description' + rec.short_description);

    //1st closed complete create new

    var mediatask = new GlideRecord('sc_task');

    mediatask.initialize();

    mediatask.setValue('request_item', current.getUniqueValue());

   // mediatask.setValue('request_item', '7002c4303b86bad07f9a342a85e45a59');

    mediatask.setValue('short_description', 'Media Recording: ' + rec.short_description);

    mediatask.setValue('assignment_group', rec.assignment_group);

    mediatask.insert();

}

[Ankur Bawiskar]

@Ankita9793 

you can have sequential catalog tasks in workflow such that 1st is closed, then 2nd is created

why to use script for this?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Dhanraj B]

Hi @Ankita9793 ,

If you are building this from scratch, I recommend you to switch to flow designer. There you can use a simple flow logic "Do the following in parallel".

something like below:

Do the following in parallel:

> Create task 1 (check wait button, so it will wait until task 1 is closed) If task 1 is closed > Create task 4 (add a condition before creating task 4 to check whether the task 1 is closed complete or closed incomplete)

> Create task 2 > Repeat the same steps used for task 1
> Create task 3 > Repeat the same steps used for task 1

-Dhanraj.