Forum Discussion

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

Re: Updating parent record when child record changes

I'm trying to suggest, that if you are not already doing so, to trigger Automation on a child record being added / edited and I'm guessing that you are now trying to trigger on the parent record (which is not being edited). If the child record needs to know something that the parent knows in order to properly Trigger, then lookup those fields down to the child.

If it is also possible that a status change on the parent record could also need to have another Automation triggering on an actual edit change on the parent.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------

3 Replies

AudreyBenenati
Qrew Cadet
6 years ago
The trigger is currently a change in a summary field on the parent table that counts compliant records on the child table. It doesn't work except on a daily automation.

Is that what you're saying? It sounds like you both are and are not saying that in different sentences. Are you able to reword "look up down to the child"? Maybe you mean something different than a summary field on the parent table that counts child records.

------------------------------
Audrey
------------------------------
- MarkShnier__You
  Qrew Legend
  6 years ago
  That is my whole point.
  
  "An Automation will only fire when a record is edited and saved. It will not fire on a record change which occurs though the passage of time or via a summary field or lookup field changing."
  
  I'm suggesting that you instead trigger on the child record being modified or added.
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  [email protected]
  ------------------------------
  - AudreyBenenati
    Qrew Cadet
    6 years ago
    Ok, I tried that about 20 times, no kidding, and it never worked. I tried it again just now and it worked. Weird.
    
    Thanks for your assistance.
    
    ------------------------------
    Audrey
    ------------------------------