Skip to main content

Hello,

In two different tables, there is a “customer” field linked to the “customers” table. This field can contain several customers (not unique).

I would like to be able to copy the customer names from the field in table 1 to the customer field in table 2 without deleting any existing data, but adding to it. (Copying and pasting deletes the old data.)

Example:

Table 1: John; Paul; Alice

Table 2: Richard; Linda; John

 

After copying to table 2:

John; Paul; Alice; Richard; Linda

Keep Richard, Linda, and John, and do not duplicate John, who is in both tables.

 

How can I do this?

Thank you and have a nice day.

 

Translated with DeepL.com (free version)

As a workaround, what if you tried creating another link to customers, pasting it in there, then having an automation merge it together?  I’ve set it up here for you to check out

And here’s how the automation looks:

The idea is to update the ‘Customers’ field with the combined values of both linked fields while separating them with a comma.  I’d also recommend using the ID value as well as that will save you some headaches in case there are customers with the same primary field value

Thanks a lot TimeSavingCo, that works !

Terms & ConditionsAccessibility statement