can you add a summary report to a calendar day

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Can you add a summary report to a calendar view

For instance the actually date would provide a summary of activities scheduled,  the current view only display 4 entries per day and I may have 60 entries 

Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
You can adjust the # of entries per day to make it a high number (blank seems to default to 4 entries), but the calendar days would each get very deep.  I'm not understanding what you mean by a summary. can you give an example?
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
Can you display a summary report or a report field on calendar?
I have a report on the form that display the status of entries for a date in a summary view

Open -12
Pending-15
Closed -20
You would need to set up a new table of Dates, and load every date (via excel) for say the next 5 years.  

Set Key field as date.

Make a 3 summary fields for # of Open, Pending, Closed and make a text formula field to list them vertically in your desired format.
Photo of Shontay

Shontay

  • 490 Points 250 badge 2x thumb
How do you make a summary field
There is a button to make a Summary field on the left side of all relationships.