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

Ask for Help
1

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

Screenshot_3

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

Screenshot_5

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 ?

2

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

2 Likes