# When adding a new row, it doesn't parse correctly from AI/JSON

**URL:** https://community.glideapps.com/t/when-adding-a-new-row-it-doesnt-parse-correctly-from-ai-json/70341
**Category:** Ask for Help
**Created:** [February 1, 2024, 12:24am UTC](https://community.glideapps.com/t/when-adding-a-new-row-it-doesnt-parse-correctly-from-ai-json/70341 "2024-02-01T00:24:10Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Rimatcom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rimatcom/32/32285_2.png) [@Rimatcom](https://community.glideapps.com/u/Rimatcom)
#### Post date: [February 1, 2024, 12:24am UTC](https://community.glideapps.com/t/when-adding-a-new-row-it-doesnt-parse-correctly-from-ai-json/70341/1 "2024-02-01T00:24:10Z")

</div>

I have a column where the AI inserts the amount in a JSON Query type column, and it works well. For example, it inserts twenty thousand as 20,000.00.

![Screenshot_4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b109cac73344b14f807b0d4d524ef33f595142e9.png)

![Screenshot_3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3dcdc291c3cfdccc7d2bd4aa05c8970408e76754.png)

The problem arises when, in an action using the ‘add row’ command, I insert that amount into another table in a column of type ‘number’. It inserts it incorrectly, going from 20,000.00 to 20.00. This means there is a number formatting issue, and it doesn’t always respect regional standards.

![Screenshot_6](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/40bec787653edd2e55e0b4dc2164c47baffe8849.png)

![Screenshot_5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/08f2cd67daa2ea5bf908e8f8587d9d82daf3b126.png)

What I think is happening is that OpenAI formats the amount correctly with the format used in my region, but when I insert it into the native Glide table, it doesn’t retain the original format and instead anglicizes it.

Any thoughts ?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 1, 2024, 12:33am UTC](https://community.glideapps.com/t/when-adding-a-new-row-it-doesnt-parse-correctly-from-ai-json/70341/2 "2024-02-01T00:33:51Z")

</div>

Can you try modifying your AI prompt to tell it to not include any thousand separators to see if it helps?