Help

Rollup fields not automatically updating when linked table updated

1958 2
cancel
Showing results for 
Search instead for 
Did you mean: 
rltourdot
4 - Data Explorer
4 - Data Explorer

Hello,

I am creating a base for performance reviews. Individuals receive Case Review scores (based on a form submission) in one table and then those scores are tabulated in a second Cumulative Scores table. My tables are linked. When I initially created my rollup fields in the Cumulative Scores table, I was able to pull the info from the Case Reviews table and populate my rollup without issue. Now when new forms are submitted, those rollup fields are not updating. I have tried adding lookup fields and automations, but I can't see to get it functioning. Can anybody help me resolve this issue?

AT rollup hiccup.jpg

AT rollup hiccup2.jpg

AT hiccup3.jpg

 

 

 

2 Replies 2
rltourdot
4 - Data Explorer
4 - Data Explorer

I've figured out that it's my linked Case Reviews field that isn't updating first. This is the automation I have set up to try and update that field. It runs through without an error, but the Case reviews field still isn't updating. 

 

Hmm, in your automation, instead of updating the record in "Team Member Cumulative score", try updating the triggering record from "Case Reviews" instead?

And so it should look like this:

Screenshot 2024-02-05 at 11.09.12 PM.png

Should work I think