Nov 23, 2021 02:22 AM
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
Nov 23, 2021 06:35 AM
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?
Nov 23, 2021 07:54 AM
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.