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.