Using Data from two tables

[Esraaa]

Hello,  Any suggestions how could the following be done!

I would like to use information from two tables
First table (Orders) contains Customer_Email and Product_ID (Filled automatically using Zapier Integration)
Second Table (Products) contains Product_ID and Product_URL

When a new order is made, an email message should be sent to the customer’s email contains the related Product_URL

 

Note: Zapier does not read Capsio Views  also does not update a table
 

[Mathilda]

On 5/31/2017 at 7:29 PM, Esraaa said:

Hello,  Any suggestions how could the following be done!

I would like to use information from two tables
First table (Orders) contains Customer_Email and Product_ID (Filled automatically using Zapier Integration)
Second Table (Products) contains Product_ID and Product_URL

When a new order is made, an email message should be sent to the customer’s email contains the related Product_URL

 

Note: Zapier does not read Capsio Views  also does not update a table
 

As far I understand Product ID in the orders table if a foreign key of the Product table, therefore you may create a relationship and display Product URL instead of ID. This article should be helpful. Then you need to insert this lookup value into the email body. It works if you use Caspio emails, I'm not sure regarding Zapier emails