Discussions

 View Only
  • 1.  Email Subscription - Any Way to Make a Dynamic Report Static?

    Posted 08-14-2018 13:48
    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.


  • 2.  RE: Email Subscription - Any Way to Make a Dynamic Report Static?

    Posted 08-14-2018 14:27
    You can make an <ask the user> report on [date] or have a report with a Dynamic filter on [date].



  • 3.  RE: Email Subscription - Any Way to Make a Dynamic Report Static?

    Posted 08-14-2018 14:30
    I have a dynamic filter included, and this is how it shows: 
    it's locked to yesterday.


  • 4.  RE: Email Subscription - Any Way to Make a Dynamic Report Static?

    Posted 08-14-2018 14:32
    It would need to be a different report that they go to for historical [Date]s.


  • 5.  RE: Email Subscription - Any Way to Make a Dynamic Report Static?

    Posted 08-15-2018 14:09
    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