Retool keeps changing column data type

💬 App Building
1
I

I have a table in the retool DB and a specific column type text. Retool keeps on changing it to type json over and over again even though my entire data flow has this data type as text. How can I prevent this from happening because this keeps messing up my entire data flow and front-end.

1 Like
4

Hi @ellenminkin ,

I understand the issue you're describing. It sounds like the database column is configured with a Text data type, but JSON data is being stored in that column, which may seem unexpected.

From what you've described, this does not appear to be a Retool-specific issue. The value that gets stored depends on what is being passed to the insert/update query.

For example:

  • If you pass a specific field from a query result, such as:
query1.data[0].name

only the value of the name field will be stored in the column.

  • If you pass a value from an input component, such as:
textInput1.value

then the text entered in that input will be stored in the column.

If the entire JSON object is being stored instead, it is likely that the query is receiving and inserting the full object rather than a specific property from it.

If you're using a different approach, could you please share a screenshot or screen recording of your query configuration and the data being passed? That would help us better understand the issue and provide more accurate guidance.