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

Question

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.

quickbasecoachd · Answer

You can make an &lt;ask the user&gt; report on [date] or have a report with a Dynamic filter on [date].

tylerparker · Answer

I have a dynamic filter included, and this is how it shows:&nbsp;it's locked to yesterday.

quickbasecoachd · Answer

It would need to be a different report that they go to for historical [Date]s.

tylerparker · Answer

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

Forum Discussion

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

Related Content

Dynamic Rule - Or statement?

Static Number Field

Subscription Reports in emails

Dynamic scaling of X-Axis

Simple Dynamic Rule Question