How to set up one time alert when client's cumulative donations over time reach X amount?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
  • (Edited)

In order to do the Quickbase Action that we desire, we need
to be able to add all of one payer’s donations together and when that sum goes over a certain amount we want a task to be added. But we cannot do a total of all the donations, is there a formula needed?

Photo of Anastasia Darwish

Anastasia Darwish

  • 72 Points

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
You probably have a a table of Payors and a relationship where 1 Payor has many donations.

You can make a summary field on that relationship to total up all the donations.

Then look that up down to the donations table.

Then you can trigger the action when the cumulative donations is > x.

But the you will also need to know if the task has been created in order to not trigger the creation of the task for every subsequent donation as well.  Assuming that these tasks are also children of the Payors, then you can also make a summary field to count up the # of that task type  and also look that up down to the donations table so as to prevent the Action from creating a task that has already been created.