I am trying to get a record to delete after 24 hours.
I have copied a formula from another thread and changed the time from hours to minutes. I have no idea about scripting so wasn’t able to implement the second part of that thread.
I currently have the “delete” column set to add the word “delete” to the formula cell after 1440 minutes. This then updates another view filtered by “if delete is empty”. In other words, if delete is empty in the new view the record will show on the front-end currently Softr.
This formula seems to work but it’s sluggish and doesn’t update on the 24-hour mark.
IF(DATETIME_DIFF(NOW(), CREATED_TIME(), ‘minutes’) > 1440, “delete”)
My long-winded and probably not well-explained question is: How do I auto delete a record after a 24 hour period?