Hi
I have a form for submitting data to a collection where I need the data to auto delete after 21 days. For this auto deletion I found this suggestion which I was going to follow
https://www.wix.com/corvid/forum/community-discussion/delete-records-automatically-after-x-days
I have also created a linked piece of text called DeleteDate so I can display to the end user "your data will be deleted on x.
I now need to get this delete date value into my collection but if I link DeleteDate to the collection to work with the submit button then the code which calculates the date doesn’t seem to put the date in the form.
I thought about adding a submit click form event to manually add the value to the collection but then i dont know which record to add it to do I?
Another thought i did have is if im going to run a daily task to delete the old data is there a way at that point to run through the collection and delete based on create date. I almost feel this is the best way but i cant get my head around the next step for some reason - I blame the heat.
Is there a cleaner way of doing all of this?