Flow Designer: How do I update a record in one table, based on values in a record in another table

RajanMurkute
Mega Guru

In my customized version of Incident Management, I have 'Assignment Group' as one of the columns in 'task_sla' table. On 'tasl_sla' record has 'Task' number which is the Incident number of the corresponding (parent) Incident record. 

When an Incident is resolved, the 'Assignment Group' value on the Incident is written to 'Assignment Group' on the   related 'task_sla' record.

Recently, while doing an upgrade, I lost values in 'Assignment Group' field in the 'task_sla' records. One can easily write a simple script and run it one-time as a back-ground job to re-populate the missing values. But I am trying to use Flow Designer and I have NOT succeeded so far.  

My flow Flow definition consists of -  

(a) Trigger = Run once ,

(b) Actions 1  = Update Multiple Task SLA records

I define the conditions for selecting the records for the above step 'Action 1'. But the problem is, how do I access the Incident tabel, using the 'Task' on each of the 'task_sla' record. I can not select 'Incident' table here using the 'pill-selector'. Do I have to write a script, using f(x) ? If 'yes' can someone tell me where do I start?  I tried the following-

var inc = fd_data.actions.current.task.etDisplayValue();

But that doesn't work. Please help.

 
1 ACCEPTED SOLUTION

takazawa issei
Kilo Expert

Hi rrmurkute,

 

You can not access table in current action

but table in "Action before current action" or "Trigger".

(Please refer below image.)

find_real_file.png

View solution in original post

2 REPLIES 2

takazawa issei
Kilo Expert

Hi rrmurkute,

 

You can not access table in current action

but table in "Action before current action" or "Trigger".

(Please refer below image.)

find_real_file.png

RajanMurkute
Mega Guru

Thanks, Takazawa. That gave me a good start. 

 
 
20 points