Skip to main content

How to avoid records split after commas

G

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

    J
    • JudoHacker
    • Inspiring
    • 22 replies
    • November 23, 2021

    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?

    G
    1 person likes this
    • G
      Guido_Cappa
    G
    • Guido_Cappa
    • Author
    • Inspiring
    • 9 replies
    • November 23, 2021
    JudoHacker wrote:

    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.

    Reply


    Most helpful members this week

    Terms & Conditions