I can't have a text cell with value 0,500

[Johg_Ananda]

This thread thread is related to this issue and has a workaround for some conditions.

Coda converts text with comma to number and breaks API / Zapier

After contacting Coda support they advised this is the intended behavior, for Coda to try to interpret the text column into something else, they refer to this as “auto-coercion”. The data going into the column was a list of numbers, so we tried to use totext() to force the API to understand the string as a string, but this was not successful. We were able to pass the correct string to the API but creating a mirror column that =totext(stringColumn) and then setting the API to pick up this colum…