Saved Search Using Leave Date Data (Was blank before)
Hello!
I am trying to make a saved search which then will connect to a workflow. I am trying to make a saved search based on when the anticipated leave date goes from blank to filled in. I don’t need it through a time range, just when our admission person fills out the anticipated leave date on the child record, this person shows up in our Saved Search to then receive an automated email.
Basically, we have families that give us a 30-day notice and as soon as they give us a leave date and we put it into NetSuite we want to send out an automated email with an exit survey. The leave date record is blank till we put that date in.
I would love any help possible! I am just having a hard time wrapping my mind around the best way to do this because I am not basing it on a time frame but when a new value is entered into something that did not have a value.
Thank you in advance!
Hi Marcy730,
Try This.
Criteria Tab
Formula(text) |
CASE WHEN {put here field id} IS NOT NULL THEN 'T' ELSE 'F' ENDIS T
In order that you want to discuss this, please contact me for more details.
Regards,