Receive notifications and approve requests

[nghilttran]

Hello everyone in the group. I have a data structure (as shown) explained as follows:
1. Business buyer (Table BUYER) has a list of components that need to find a supplier (Table PRODUCT)
2. The supplier business (Table SUPPLIER) selects the buyer business's component list to provide (Table PRODUCT DETAIL)
How does the buyer business in the BUYER table receive notification and approval to "Agree" or "reject" when a SUPPLIER chooses a component of a BUYER in the PRODUCT table to supply? Thanks to the members in the group for guidance on the above solution. Thank you

[Aurelien · Accepted solution]

Hi @nghilttran 

You would use the References between the tables 🙂

I would suggest to build a bot this way: "When adding an item in PRODUCT_DETAIL, send a notification to [ma_buyer]"

The notification would be an email with an access to the app on a detail view type with choice "approve" or "reject".

[nghilttran]

Thanks you very much