Is there a way to automatically perform an action that deletes a row at a specific time, or any other means to periodically delete a row satisfying some criteria?
I have an ordering app for businesses and all orders should be deleted by midnight of that day. If anyone has any tips or suggestions it would be greatly appreciated as workflows and reports donโt have the functionality I need.
Create a Report with the schedule you require. In the Action 1 section choose โChange Dataโ and pick โDeleteโ. Youโll put the rule which decides which row to delete in โConditionโ
Thanks for your reply. Iโve looked at reports, but there isnโt a change data option - thatโs only for workflows.
So you need to choose the option of โForEachrowInTableโ. Sorry assumed youโd be doing that. Then โChange Dataโ shows up.
Thank you so much! I set up my record, but it isnโt working, at all.
Iโve tried syncing my app, deleting previous offers, but the record doesnโt delete the offer at the intended time. Not too sure what the issue is though.
Hi @kchatr
One way to do this could be create a view of the orders for today with the condition [Order date]=today()
Then will only see the orders of the current day, but you still have the other orders in case you need them to analize data or check any details
Does this solution suite you?
It would be preferable if the order was deleted as it would make things much smoother and require less modification to the existing structure @Guillermo
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |