Cron job to change database entry?

[Desmo]

Hi clever programmer types

I'm setting up some software at work to make our workflow a little smoother, quicker and more automated. I'm using vtiger open source software to do this.

I've currently got a workflow setup so that when an "Email Supplier" tickbox is true, that supplier is emailed the quote. Trouble is, the supplier gets emailed every time the quote is modified and saved. This workflow is run with a cron jon.

What I'd like to do is have the "Email Supplier" tickbox set to false each time the cron job is run. I've found the entry in the sql database but not sure what to do next.