Jump to content
  • 0

Using Data from two tables


Esraaa

Question

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
 

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...