how to update field if related list updated with record

shweta14
Tera Contributor

how to update field if related list updated with record.

I have one form on that having related list from other table.

when that related list updated with record then I have one field on current form which should get updated.

how to achieve this?

1 ACCEPTED SOLUTION

Sebas Di Loreto
Kilo Sage
Kilo Sage

Let me start by saying that every related list is a record on another table that is "somehow" related to your main record. As an example, a change_task is related to the change_record through the change_request field.

 

SebastianDL_0-1668092024473.png

 

So, the change task is a related record to the actual change

 

SebastianDL_1-1668092107062.png

So what you want is that when something happens at the change_task level then that triggers an update at the change_request level right?

What you need is a business rule on the change_TASK level (related list table) that monitors the condition you want. Then the code will Glide the change_request table where (in this case) change_request.sys_id = change_task.change_request. Finally you will update() that record.


If I helped you with your case, please click the Thumb Icon and mark as Correct.


View solution in original post

1 REPLY 1

Sebas Di Loreto
Kilo Sage
Kilo Sage

Let me start by saying that every related list is a record on another table that is "somehow" related to your main record. As an example, a change_task is related to the change_record through the change_request field.

 

SebastianDL_0-1668092024473.png

 

So, the change task is a related record to the actual change

 

SebastianDL_1-1668092107062.png

So what you want is that when something happens at the change_task level then that triggers an update at the change_request level right?

What you need is a business rule on the change_TASK level (related list table) that monitors the condition you want. Then the code will Glide the change_request table where (in this case) change_request.sys_id = change_task.change_request. Finally you will update() that record.


If I helped you with your case, please click the Thumb Icon and mark as Correct.