Skip to main content
Question

How can I send a notification to a specific email direction with specific data?

I have a need with a notification:

Example:

I have a field Supplier with values "A", "B", "C" and "D" ( these are emails and it is a text field )

How can I make a notification that is sent to the Supplier "A" with the data of the records that match an specific rule in the notification, and only the records that have the Supplier "A"? ( not the records with the value "B" or "C" or "D" )

The Supplier "B" should receive the data of the records with Supplier "B" and so on...

Is this possible?

Thanks a lot!
    This topic has been closed for replies.

    If you are okay, you can try a subscription. Create a separate report for Supplier A and then subscribe that report to Supplier B. Hope that helps.
    Ummmmm... interesting... I'll try!! Thanks a lot!
    Are these Suppliers Users?

    Are they to receive an email daily or is this to be triggered when a record is edited?
    Not users because there are a lot... and it is not a user field, it is a text field filled with emails ( example: supplierblabla@suppdomain.com. 

    The thing is... I'm not really sure if QB handles the feature to send multiple emails based on a field with specific info to each mail...
    O, so Quick Base does not let you send a regular overnight automatic Subscription to non users and our Suppliers are not Users.

    But you can make a Report of all Suppliers who have Open Products not received and by using a special form for this purpose include an embedded report of all Open Products.

    Then you can Make a subscription report to come to you daily.

    Then on the report you can make a URL formula button which will update a date/time field called  [date/time emailed to Supplier] with the current date and refresh the report.  The report will have a filer on it to not include Supliers emailed today.

    So each day or as often as you choose to send the report, you or someone will mindlessly click a button on a record and trigger an email to Supplier based on a Open Notification and the Notification will be set to use a specific form for this purpose.

    Once you get that working, it it becomes annoying to push the button so many time, you can contact me or another QSP who can install a script so that you only have to push the button once, to trigger separate email Notifications to all Suppliers on that report.

    If you  want to completely Automate that with no button pushes, I can hook you up with Juiced who can, for a monthly fee, completely automate this with no button pushes.

    I can help you with the URL formula button if you like.

       
    Ummmm it is a possible solution... with only one "but"... if I create a report and make a subscription, in this report will be every product of every supplier, and If we create an email for every supplier... all of them will see each other products... not only theirs, right? 

    The perfect working should be each supplier receive only his products.
    Each supplier will receive an email Notification for only their company and with an embedded report of only their products.
    Terms & ConditionsAccessibility statement