How to avoid records split after commas

The problem is most likely in Zapier, not Airtable.

I’ve used the Airtable API intensely in the past year while building PowerImporter and I’ve never seen this problem before.

Can you share screenshots of your zap?

My zap is quite long. I can share all the tasks inside my zap.

As you can see I update two different records in 2 different tables. The problem comes in only when commas are added to the first record.

Bumping this again as I’m running into the same problem and I don’t believe it has anything to do with the automation.

I have a list of customer survey responses. Some clients provided multiple responses, therefore we have several records with the same data in the ‘Client’ field.

I am trying to link to another table so I can show a de-duplicated list of the Client names with their corresponding responses, but the linking is going wonky on me because some client names have commas in them (ex. “Acme, Inc.”). When linking, Airtable picks up the data from this column as TWO DIFFERENT client names, “Acme” and “Inc”. Pretty painful for what seems like a small problem.

Perhaps there’s a simple way to edit the ‘Clients’ column to tell Airtable not to split the record even when there are commas?

^ After some fiddling, toggling off “link to multiple records” seems to have worked for me now although I’m not entirely sure what I changed to make that work.