Skip to main content

Four tasks, repeated daily, total amount per day

  • December 22, 2020
  • 1 reply
  • 10 views

Sorry for the newbie question, if I have the same four tasks repeated daily and I need the totals for those noting respectively, do I need four separate tables to monitor date and total or is there a way to have all four tasks on one table?

The end goal is be able to monitor task totals over week/month.

1 reply

Databaser
Forum|alt.badge.img+25
  • Brainy
  • December 24, 2020

Hi @Copper

Do I understand correctly that u want to have the totals for tasks completed? Of for information that you add to the created tasks?

I would have a table with the 4 tasks and a table where the daily copies are made via an automation that triggers on the present date via “when record is updated” (formula field with “Today()”) and fills a linked field with the original 4 tasks. Using a conditionally “rollup” or “count”, you could monitor the numbers you need.