I need to trigger notifications based on a shipment table

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have a shipment table built inside a project table. In the table the form allows you to select the parts type and the shipment type of delivery or shipment and attach a confirmation with a fulfilled check box to trigger the email. I currently have notification set up based on fields in the project table but now want to use a common table. My question becomes as how to use the fields in the new table and have the notification look at the most current shipment/delivery in the new table. Each of the two types of shipping/delivery and they parts types have their own notifications (four total notifications - (2) shipment notifications and (2) delivery notifications.

Also wondering if I could combine all of this into one notification and just work off of the field names for the most current entry in the log under each project

Photo of Joey Zint

Joey Zint

  • 1,800 Points 1k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
Can you clarify your structure?  I assume 1 Project has many Shipments.  Do the Shipment Notifications trigger when a Shipment record is changed or are you doing something on the Project record to fire off a Notification form the Project record.
Photo of Joey Zint

Joey Zint

  • 1,800 Points 1k badge 2x thumb
I load the shipping confirmation, enter the date, tracking number, and shipping method....I then check a box that the shipment is on its way. That check box triggers the notification. Currently I have a shipping setup for each of two part types and then a setup for two parts types for delivery confirmation....all triggered with check boxes. Now I have this single table that we be a list by type. I am thinking I can do two notification now...one for shipments and one for deliveries. I am little confused on what it will take to look at the current record in the list.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
Why not just trigger the Notifications off the child shipments table?