Help

Re: How to avoid records split after commas

844 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Guido_Cappa
6 - Interface Innovator
6 - Interface Innovator

Hello, I have a table where all records are auto populated by a Webflow form submission through Zapier.
Everything works fine except one small thing. Every time a user sends a form and the main text field has commas in it Airtable splits this record in multiple records.

Example:

Form Submission:
Watchmen #12 "A Clock at Midnight, Its Face Running with Blood, Cover Original Art"

Airtable Records:
1st Record: Watchmen #12 "A Clock at Midnight, Its Face Running with Blood, Cover Original Art
2nd Record:Watchmen #12 "A Clock at Midnight
3rd Record:Its Face Running with Blood
4th Record:Cover Original Art

Is there any way to avoid this? I just want the first record not the second, third or fourth.

Thanks

2 Replies 2
JudoHacker
6 - Interface Innovator
6 - Interface Innovator

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.

Screenshot 2021-11-23 at 15.51.10