Forum Discussion

MichelleCoslet's avatar
MichelleCoslet
Qrew Assistant Captain
7 years ago

send notification when all quotes are completed

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.

App builders
NotificationsEmail
Relationships
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    7 years ago
    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.