Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
8 years ago

Send notification to email specific address in the record?

I will need some detailed assistance with this.
Field:  BPro Mgr Email (this will be a lookup field from jobs table)
Field:  EWO/EPO/PO # (text field)
Field: Purchasing Mgr (this will be a look up field from jobs table)

Ok...
When EWO/EPO/PO # field changes...
Send email to
BPro Mgr Email  AND to
Purchasing Mgr Email

Let me know if you need more info...thx
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    There are different ways to do this, but since it sounds like these are users, I would make a list user field called [BPro and Purchasing manager userids] with a formula like

    ToUserList([Bpro userid],[Purchasing Manager userid])

     and then look that up down to the Jobs table and send the email to that choice - it will be offered as a choice.