Email Subscription - Any Way to Make a Dynamic Report Static?

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
I have a report that sends out yesterday's data entry summary to those who need it. However, if they want to look at a report more than 1 day old, when they click the link to view it in QuickBase it dynamically adjusts to the current date and displays yesterday's data, no matter the date of the email. I'm currently filtering records to those which have [Date] = Yesterday. Any help on how to make these emails show historical data/past reports would be appreciated, or if that isn't possible any tips on how to archive those reports as they are created.
Photo of Tyler Parker

Tyler Parker

  • 714 Points 500 badge 2x thumb

Posted 3 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
You can make an <ask the user> report on [date] or have a report with a Dynamic filter on [date].

Photo of Tyler Parker

Tyler Parker

  • 714 Points 500 badge 2x thumb
I have a dynamic filter included, and this is how it shows: 
it's locked to yesterday.
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
It would need to be a different report that they go to for historical [Date]s.
Photo of Tyler Parker

Tyler Parker

  • 714 Points 500 badge 2x thumb
I ended up simply creating a standalone button that pulls up a copy of the same report. This copy prompts the user to enter a date. So I did achieve the result I was looking for, almost a simulation of someone looking through a file cabinet, but not in the exact way I hoped. Still works though! Thanks for the advice