ContributionsMost RecentMost LikesSolutionsRe: Automation: Trigger on Summary Field ChangeGot it. User error on my part. I think I had too many filters when I had Record DI# on the left. It works now, quite successfully. THANK YOU! ------------------------------ Matthew Witzgall ------------------------------ Re: Automation: Trigger on Summary Field ChangeI've modified it 4 different ways, still with no success. Thoughts on what the filter on the action should be? ------------------------------ Matthew Witzgall ------------------------------ Re: Automation: Trigger on Summary Field Change ------------------------------ Matthew Witzgall ------------------------------ Re: Automation: Trigger on Summary Field ChangeI changed it (I actually saw it after I sent the screenshot!). It still did not work, even with referencing the Record ID# ------------------------------ Matthew Witzgall ------------------------------ Re: Automation: Trigger on Summary Field Change ------------------------------ Matthew Witzgall ------------------------------ Re: Automation: Trigger on Summary Field Change ------------------------------ Matthew Witzgall ------------------------------ Re: Automation: Trigger on Summary Field ChangeI have not yet tried this option. ------------------------------ Matthew Witzgall ------------------------------ Re: Automation: Trigger on Summary Field ChangeYes. Still no luck. ------------------------------ Matthew Witzgall ------------------------------ Re: Automation: Trigger on Summary Field ChangeI tried this, and it did not work. ------------------------------ Matthew Witzgall ------------------------------ Re: Automation: Trigger on Summary Field ChangeHi Mark. Thank you for the quick response. Here is an overview of the problem, in detail. I have two tables, one for Purchase Orders, and one for Line Items. The Line Items are parts which are ordered. There is a checkbox on the Line Items record which denotes when the part is received. The Purchase Order record has two summary fields; one totaling Parts Outstanding, and one totaling Parts Received, derived from that checkbox. I am trying to create an automation that automatically changes the PO status to closed when Parts Outstanding =0 and Parts Received is >0. My only concern with the solution you noted above is that the data may change multiple times, as parts are not received all at once, so it may not always accurately reflect the Parts Outstanding =0. ------------------------------ Matthew Witzgall ------------------------------