I have a purchase requisition form setup with 6 line items a user can enter.
1-item: broom 1- price: $1.00 1-Due Date: 6/26/2014
2-item: cart 2-price: $15.00 2-Due Date: 6/27/2014
I want to setup a notification that when Due date is equal to today, an email will be sent to the "requester" notifying them that their Broom was due today.
Tomorrow, 6/27/2014, I should get another email saying that my Cart is Due today.
Having issues setting up this notification. any ideas? Is there a way to add a formula field into the form then hide it saying "when 1-due date=today, send email notification to requester" Then have that same formula field for each line item?