error when using automation update colums sql server

[hoangviet_2023]

I got an error when using action "set the values of some columns in this row" to update number 456712 for column Total paid (Numberic 16.0) in sql server table but got error "String or binary data would be truncated" Can you help me?

[Marc_Dillon · Accepted solution]

What happens if you insert that value into the column directly on the database table, not through appsheet? What is the column type set as in appsheet? Does the error happen only when using the action, or also if you manually enter the value through a form view?

[Marc_Dillon · Accepted solution]

What happens if you insert that value into the column directly on the database table, not through appsheet? What is the column type set as in appsheet? Does the error happen only when using the action, or also if you manually enter the value through a form view?

[hoangviet_2023 · Accepted solution]

I have tried setting the column type as in the sub table as numeric or decimal. error occurs when using all Actions including manually entering values through form view

Thanks You