cooper collier 1/12/2016 8:07:40 AM
Wicked!! Its always a pleasure seeing someone who makes the PRO in programmer!
I totally missed the NotLeft command! This does 100% perfect what I was proposing. It allows you to essentially pick out sections from a text string. I tested it with an email like this
this is what goes in body
used the formula like this...Left(NotLeft([Body], "priority:"), "\n")
and it picked up "low" perfectly!
adding lower would take care of people like me who cannot consistently use the shift key..
Left(NotLeft(lower([Body]), "priority:"), "\n")
Using this its possible to test if the required information is in the email. Then actually reply back to the sender if its not... I discovered the "the address listed in column" notification setting will not recognize [from] but you can make a new formula email column set it to =[from] . then you can automatically send replies back to the sender.
This will make A LOT of people happy. Especially ME!
90% of my work comes to me in email... 90% of the time, I plan to add a task later. 90% of the time I totally forget to add the task. and 90% of the time, people yell at me because I forgot them!