Click here for your $100 Quick Base App Audit!

Formulas + Webhooks = Dynamic Record Creation

Follow

Comments

2 comments

  • Hongkun Liang

    Hi Chayce, it's a very good example.

    I have one question.  if one field value includes comma, how to handle this?

    I tried to add double quote to each field in the formula.  The numeric field seems fine in the child table. However, the text field becomes this &quote;Hongkun&quote; instead of Hongkun.

    Any suggestion on this?

    Thanks very much for your time!
    Hongkun

    0
    Comment actions Permalink
  • Dev Team

    Hi Hongkun - in this example - your best bet is to probably do a Quick Base SearchAndReplace() function to remove all of your commas. Because this is meant to be a simple CSV method - having additional commas can cause issues like you've seen. 

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk