Can an email be sent when all tasks in a project have been completed?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I can't seem to find a way to trigger an email when all tasks in a project have been completed. A CountIf statement would be my go to and compare it to the total number of tasks, but Quickbase doesn't support CountIf.
Photo of Jennifer

Jennifer

  • 182 Points 100 badge 2x thumb

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
You can make a summary field of the # of tasks.

Then a summary field of the # of completed tasks.



Then look those both up down to the tasks Record and try to fire a notification based on those fields being equal after the record is saved..  I suggest that you include both fields in the actual notification to force QuickBase into calculating those two fields before firing the notification.  I have seen examples of timing issues where the summary fields did not get calculated in time to fire the notification. .. and i see that Laura is typing too ....
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 3,770 Points 3k badge 2x thumb
and here's my solution....

If you can identify for each Project what the last Task's Record ID# is; and then feed that value back down into the Tasks table, you can fire an email when the Record is saved (and is completed) and the Record ID# of the Task matches the "Last Task" record ID# to notify someone that the Project has been completed.


If you are using a "template" task system; I have used a formula checkbox in the Template Task records to identify which is the last task for that Template. I am then using that to determine at the Project level when the Project is complete and firing out a subscription to notify Project Managers that Projects are complete but the Statuses have not been updated (for example).  You could use this same "mechanism" to combine that with the Record ID# (Summary Field to pickup the Record ID# of the Task where [Last Task] is true) and send that back down to the Tasks and fire the email as described in the above paragraph.

I waited to see what Mark wrote, before throwing in my two-cents.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
You probably have to make a formula field where the two counts match, like [All tasks complete?] and trigger when that field changes.  It may or may not work or you may have to fiddle with it to get it working, like I said there can be timing issues as to when those summary fields get calculated.
Photo of Jennifer

Jennifer

  • 182 Points 100 badge 2x thumb
I actually figured it out but thanks for your input. I ended up creating an email notification that checked whether the % Complete for the tasks was 100. It's working great now.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
Thx for letting us know.