Automatic copying of data to a column of the "link other record" type

Sure, let me elaborate.

I understand that you have a table with orders and a table with products. In the table “products”, you have all your products including the SKUs.

If you import the SKU into the table “orders” via Zapier, you cannot do this directly in a link column, but only in a text column. But this is enough.

Here’s what you do:

  • Zapier pastes the SKU in a text column
  • You run the data processing operation “auto add link” (see below)

image

This this works for you, you can use the same operation as an automated action (see below)