The CreatorCon Call for Content is officially open! Get started here.

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

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

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.