How can I automatically delete records from a table when today's date is say 30 days after the records' creation?

  • 1
  • 1
  • Question
  • Updated 5 months ago
  • Answered
Photo of Max Allen

Max Allen

  • 302 Points 250 badge 2x thumb

Posted 5 months ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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
Photo of Max Allen

Max Allen

  • 302 Points 250 badge 2x thumb
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.