Script - Look for field then email someone with other fields.
I am doing an inventory database. There is a product name among other fields. There is an Amount in Stock field and a reorder level with a field that is automatically calculated based on the amount in stock and the reorder level. So here is what I am trying to do.
Go through all records.
Find all the ones that have the word reorder in the timetoreorder field.
If the itemwasreordered checkbox is checked then continue to the next one don't email.
Send an email to firstname.lastname@example.org
The email should say. Please order the following... [ProductName] [ItemNumber] [Vendor].
If it is supported I would like to do it in one email. If not then an email per item is fine too.
Could this be setup to run automatically every night?