Hi just want to share this trick where in the view the data of the particular row will be visible only for a specific time.
Go to data>>Slice>>Row filter condition and input ( totalminutes(now()-“03:15:30”)-totalminutes([Access datetime]-“03:15:30”)<15)
where view will be visible for 15 mins
Note that you MAY run into performance and/or battery-charge problems as your data set grows. A row filter expression with NOW()
has to be reevaluated every second for every row of the underlying table.
Thanks, I didn’t know that. Just implemented this and it worked so shared it here. But I will definitely keep this in mind.
Steve, I have taken to using UTCNOW() for timestamps and convert to local time with a virtual column as [utcTimestamp]-(UTCNOW()-NOW())
Is there a preferred way to do this? I’m aware of the usertzoffset() formula but I’ve not been using it.
The way you’re doing it is how I’d do it.