I have a button the creates an output row that is a trigger row for Zapier. One of the columns is setup as comma separated values (CSV) so that Zapier can parse them as ‘line-items’. For example we have text column [Quantity] with the string “3,843,900,22”, Zapier can parse this string into 4 integers: 3, 843, 900 and 22.
This works fine, until you have values that could represent a number in the #,###.00 format. For example if you have the string “3,240”, Coda auto-converts this string into an integer “3240” and passes that value, not the original string, to the API.
Zapier is receiving “3240” where it is expecting two comma separated values, 3 and 240 resulting in the zap failure.
This bug is bad because it is not intuitive and only reveals itself in the edge case scenario where you have values that match this pattern. In my case, I have been using a doc for over two years before it broke like this.