search

dcolley / integromat-facebook-support

0 stars 0 forks source link

[QUESTION: Adding new relation to Airtable] Hi everyone! I'm sending purcha... #75

Open dcolley opened 3 years ago

dcolley commented 3 years ago

[QUESTION: Adding new relation to Airtable] Hi everyone! I'm sending purchase orders and clients' information from Woocommerce to Airtable.

So there's a table called ORDERS and a table called CLIENTS that are related. A CLIENT should have all ORDERS purchased in the relation field. Whenever an order is made, it sums 1 row to ORDERS and checks if that client is already registered.

  1. If not, it creates it with that ORDER's relation.
  2. If it exists, i want Integromat to add that new ORDER to the ORDERS RELATION field. But, what it does is replacing previous orders with the new one. Below there are several images that show the case.

Can you give me a hint? Thanks in advance for your kind help!

dcolley commented 3 years ago

Source: copied from https://www.facebook.com/groups/integromat/permalink/3968662866577650/