Skip to main content
Question

Notifications to a Selected List

  • Oct 21, 2021 7:23 PM UTC
  • 0 replies
  • 37 views

I am trying to create a notification on a table, but I need the ability to select specific Vendors to send the email to.

What I have:

Vendor Table --> Contacts Table

Project Table --> Contracts Table 

When I am on a Project screen, I see all of my contracts associated with it. 


I would like to add a button (see above) here that would allow me to choose from a list of ALL vendors in the system, that I can send a notification too.

I believe I need a lookup of some kind, but a Relationship allows me to Add Vendors, not choose the ones I want.

My thought is to somehow create a new table that stores a Vendor/Contract relationship and go from there, however I am not sure exactly how to make it so I am easily choosing vendors (again not creating).

Thanks!

------------------------------
Matt Holmen
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Are you trying to send Notifications to Vendors or more likely Vendor Contacts which would have email addresses.

It sounds like you need a Many to Many join table where One Contract has many "Contract Contacts" (new table)  and One Contact is used on many "Contract Contacts".

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------