Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Support
Quickbase University
Skip main navigation (Press Enter).
Toggle navigation
Search Options
Home
Communities
All Posts
All Communities
My Communities
Getting Started
Events
Qrew Groups
Discussions
View Only
Community Home
Discussion
64.7K
Library
549
Blogs
177
Events
0
Members
46.7K
Back to discussions
Expand all
|
Collapse all
sort by most recent
sort by thread
How can I automatically delete records from a table when today's date is say 30 days after the records' creation?
Max Allen
06-18-2018 13:51
QuickBaseCoach Dev./Training
06-18-2018 13:56
Re: "How can I automatically ...", No problem, use an aptly named feature called "Automations". Very ...
Max Allen
06-20-2018 14:19
It seems you can only do automations based on numeric data types, so I just created a numeric formula ...
1.
How can I automatically delete records from a table when today's date is say 30 days after the records' creation?
1
Like
Max Allen
Posted 06-18-2018 13:51
Reply
Reply Privately
Options Dropdown
2.
RE: How can I automatically delete records from a table when today's date is say 30 days after the records' creation?
0
Like
QuickBaseCoach Dev./Training
Posted 06-18-2018 13:56
Reply
Reply Privately
Options Dropdown
Re: "How can I automatically ...",
No problem, use an aptly named feature called "Automations". Very recently they were improved to be able to run an a scheduled basis. So they can run every day or every week to delete records meeting a certain criteria.
Here is some help on Automations.
https://help.quickbase.com/user-assistance/cs/cs_about_automations.html
3.
RE: How can I automatically delete records from a table when today's date is say 30 days after the records' creation?
0
Like
Max Allen
Posted 06-20-2018 14:19
Reply
Reply Privately
Options Dropdown
It seems you can only do automations based on numeric data types, so I just created a numeric formula that was 1 if the file is >30 days old and 0 otherwise, and then set the automation to run off that field as opposed to the date field.
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Copyright . All rights reserved.
Powered by Higher Logic