topic Re: Preset Previous Day's Date Filter in App Development

Preset Previous Day's Date Filter

tahirhasanjafri — Wed, 25 Sep 2024 14:47:03 GMT

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.

Re: Preset Previous Day's Date Filter

MatheusC — Wed, 25 Sep 2024 17:32:13 GMT

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

Re: Preset Previous Day's Date Filter

chriscammers — Wed, 25 Sep 2024 19:46:08 GMT

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"