Why not make it a user event script on before subm...
# suitescript
l
Why not make it a user event script on before submit or better yet, make it a scheduled process that will run daily.