I have a database with tables
A - Products
B - Vendors
C - Requests from clients.
B is linked to A
C is linked to A
I want to give clients option to send request about specific product. An introduction to the vendor.
I have a form for clients to post request about specific product in A and that goes to my table C.
In that form, I have automatic pre-fill of the form with selected product from A.
So inside table C data about clients - email / message / which product they asked for.
I want to sent and auto email to the client and the vendor of the product.
I have used automation to send email when new record gets created in table C and it work good.
But I don’t know how to automatically get email to my table C if a new request is created.
So in table C I have linked records from A - a product name. Can I automatically import vendor email based on that? I could put the vendor email into A table but don’t know how to import that automatically?