Add a Row with Find and Replace (no more fix tasks)

Tables: Add a Row & Update a Row creates a fix task if your value includes quotes. The fix task message says:

There was an error parsing values: Trailing quote on quoted field is malformed. Please ensure comma-delimited inputs are formatted correctly.

I would like to share my solution since this issue comes up often for users and in my own internal processes.

Use this field formula to find quotes and replace with double quotes:

result = fields['field-name'].replace(/"/gi, '""')

With this field formula, "ipsum" turns into ""ipsum"". Then, in the Add a row Values field reference setting, you should have "{{field-one}}". This adds the value into the destination data table column as expected.



The following post includes a similar scenario that can help you debug: