Temporary User view

[Mouldi_Zeghouan]

Hi,
Any idea how to hide the new data record rows for the user view like 1 day (24 hours)temporary ?

Thanks

[Lavanya]

Hi,
Hope It will work.
You can use the security filter for hiding the data to the user.

[1minManager]

Assuming you’ve got a column that records creation as a date time, simply use a slice with this formula:

DATE([CreationDateTime])<Today()

This will only show records for yesterday and older. If you want it to be 24hours exactly thats a bit more complicated

Simon@1minManager.com

[Aurelien]

In addition for this

1minManager:

If you want it to be 24hours exactly thats a bit more complicated

Please see section " Examples that Compare Dates, Times, and DateTimes"

help.appsheet.com

Date and Time Expressions

Incorporate dates and times into the behavior of your app.

The example from this section:

• [Timestamp] > (NOW() - 1) : a Yes/No value indicating whether the DateTime value of the Timestamp column is within 24 hours of the current date & time.

[1minManager]

@Aurelien is right this is the simpliest way to do it. Not one I’ve really used

What I’d normally do is calculate the difference between the timestamp and Now() as a decimal then see if its > 24.00. Defiantely more complicated but sometimes later on you might need a formula that can check for any duration rather than just exactly 24hours

[Aurelien]

Agree