in your case, I suggest a scheduled script that se...
# suitescript
b
in your case, I suggest a scheduled script that sets your custom field