Skip to main content
Question

send notification when all quotes are completed

  • July 12, 2018
  • 0 replies
  • 21 views

Purpose of my app is to request Quotes from our suppliers.

Lets say I send them a request for quote for 5 components that are used on project ABC123. And an additional 3 request for quotes for components used on project BirthdayCake.

I want to be notified when all 5 components have been quoted for ABC123 in one email.

And a separate email once all 3 components have been quoted for Birthdaycake.


I figured i would create a summary field, however that would require me to setup a relationship between two tables. My app only has one table.

    This topic has been closed for replies.

    • ArchiveUser
    • Registered
    • July 14, 2018
    It sounds like you're not making the most of your application. If you're requesting Quotes from Suppliers, and each Quote could have multiple Components for the same Project, I would suggest setting up an application that is much more in depth. An application that has one table is really just a glorified spreadsheet. 

    Based on your information, I see an application that would have at least these tables:
    • Clients
    • Projects
    • Quotes
    • Quote Components
    • Components (just a general listing of all possible components)
    • Suppliers
    While you wouldn't be able to setup an email notification, you could setup a report on your dashboard that would show you all Quotes in a specific status and the # of Quote Components that have been completed vs pending, or something similar.
    Terms & ConditionsAccessibility statement