Database Refresh

[psdevela]

Is there a way to refresh the database automatically after a week of uploading?

Could it be emptied after a week again so another set of data could be uploaded?

[1minManager]

Whats the reason for this, what are you trying to achieve?

[psdevela]

Hello! I need to display a new report on the dashboard weekly. I’m not sure if I can archive the data but refreshing or uploading new data is alright.

[Marc_Dillon]

Maybe you can use a Slice to just show the current week’s data?

help.appsheet.com

Slices: The Essentials

Display only certain rows or columns of your table with slices.

[psdevela]

Thank you so much! Will try this out.

[1minManager]

As @Marc_Dillon said, use a slice. The formula you’ll need will be something like this to show last weeks data

AND(
Year([Date Column])=Year(Today()),
Month([Date Column])=Month(Today()-1)
)

[psdevela]

Thank you very much! The formula would be helpful. I will try it out.