Automation auto convert number text format into real number

[desmond_lee]

Hey guy

Why automation bot change my number formatted into text back to real number again? This cause my save form to get hang there when ai submit an TOOL AUDITOR ID. This column has a data format example 2264 or M165. Its a mix thus I select all to format type to text

See below table that column TOOL AUDITOR ID the submitted setting is Text but the add another row in the below tabale become pure number. 

The error in save the form

[AleksiAlkio]

Try to wrap the column with a TEXT() expression like TEXT([Audit Finding]) and see if that solves it.

[desmond_lee]

I try to add before I post the question but no luck. This table on the right side is the source I warp TEXT ([TOOL AUDITOR ID]) and it does not work 

[AleksiAlkio]

Is the column type in gSheet set as "Pure text"?

[desmond_lee]

It's default. Nothing is set on gsheet. The form save to the actual database is also default set as automatic and there is no issue. Below is the add new row table after the form is saved

[AleksiAlkio · Accepted solution]

If the column is meant to have text values, change the whole column to Pure Text. Then gSheet is not trying to be clever and change them to numbers.

[desmond_lee]

Phew what a biggg mistkae I have made. The source  table column TOOL AUDITOR ID is text type and the Target column is NUMBER..... resolved ! Anywhere thank you again