Script, workflow or scheduled Mass update
We have a script that is ran when a user clicks a checkbox on a sales order. I want to automate that for a certain customer where each night all the SO’s for that customer have that chaeckbox marked as true and have the script that is triggered by the action run. What is the best practice, a script, workflow or scheduled mass update?
There isn’t necessarily a best practice. Depends on your size/who is maintaining your system/etc. A scheduled workflow or mass update are the most friendly in general for admins/anyone new would come along. It’s usually easy to look at them and figure out what is going on. Script is certainly fine if you know there is developer there who can monitor/maintain in case something needs to change. If it’s doing something really simple off the checkbox, I would strongly consider going the non-code route for ease of long term maintenance.