We have a case table extended from task table. And we have another custom table that has a string field, consider the field name as " test". My requirement is whatever the value i updated in the field "test" should get captured in the activity format

[Saranya16]

Hi,

We have a case table extends from task table. And we have another custom table(scope: Global) that has a string field, consider the field name as " test".

My requirement is whatever the value i updated in the field "test" should get captured in the activity formatter of case table.

Is it possible to do? Because both the tables are not related except in the case table we have a custom field that referencing this custom table.

[MattiasJonsson · Accepted solution]

I would do that in Flow Designer.

You trigger when your table in Global is "Created or Updated" with a condition for your "Test" field set to "Changes".

Then, you do a "Look up records" in your Case table, where the Reference Field = Trigger.

Then since you look up multiple records, you do a for-each.

For each record, you do an "Update Record" and write to "Additional Comments" for the Case Record(s) found.

Here's a quick mockup recording using the above flow.

If helpful or correct, please indicate so!