I have a parent and child relationship between two tables. Updates are made to child records in a grid edit and the status of the parent is updated via a formula when the record is saved (if the status of all child records is complete, the parent record status is also complete).
I need a notification on the parent that triggers when the status is complete.
At the moment I can't trigger any 'record updated' notification on the parent by updating the child records in the embedded grid edit table and saving the parent. I'm hoping it's not the case, but I think it could be because of a timing issue (the status of the parent not being updated before the check for a change to the record is made) or because changes to formula field values aren't regarded as a change to the record.
I could create a custom button that forces a change to the parent when the record is saved (by updating a dummy field), but wanted to see if I was missing something obvious.