Preset Previous Day's Date Filter

[tahirhasanjafri]

I have an app where there are tables with some daily data. I want to setup a date filter in such a way that whenever the app is opened by any end user, only the previous day's data is shown by default. Creating a filter and setting it as a default bookmark limits the filter to that one specific date only and it doesn't change every day. 

[MatheusC]

Hi, @tahirhasanjafri 
I'm not sure if I understood correctly about the marker being limited to a date and not changing.

I'll leave some guesses, I imagine there is a date filter, so instead of leaving a fixed date, leave it dynamic, in your filter search apply your marker, like:

=FieldDate=today()-1

Or if you want the dates to be from the previous day and the ones before it, change the sign from = to <=:

=FieldDate<=today()-1


-Regards, Matheus

[chriscammers]

I suggest you create a field in your calendar table that has static values but change relative to the current date so that the bookmark does not have to change but the underlying data does change.

For example I have fields in my calendar that gives the "relative" difference between the current day and the date of the record. So in this field the current day is 0 and days in the past are -1,-2,-3,-4 and so on until the end of the calendar. If I set my bookmark on the relative date then if the value is -1 the bookmark will not need to change each day becuase the "previous" day will always be "-1"