So, here’s another in my long line of small issued in the API. I have simple formula fields in my table that add other columns together. It’s literally field a = field x + field y + field z. When I return field a, the api doesn’t return “0” properly. Instead, I get the most recent non-zero value in the field.
It should look like: It Looks Like:
I’m using the API to generate simple reporting in Google Sheets, so I have apps script turning the api json object into an array of strings. I’ve verified that there isn’t any weird behavior here with 0 values in my implementation of the apps script. The api only does this on calculated fields.
My only idea so far is that the api is treating the 0 value in the calculated field as empty, but I’m not sure that would cause the behavior or what to do if that is the case. Thanks for any ideas.