data input from appsheet has a ' in front of the value

Hi, 

When I am key in a value in appsheet , the value is a little difference in google sheet.

eg. "1115" as be below screen,  the actual value send to google sheet is '1115. It has a single quote mark in front of the value. 

How to remove this single quote mark? 

LeaDesign_0-1665027726372.pngLeaDesign_1-1665027882942.png

 

 

 

 

0 2 44
2 REPLIES 2

That is because the Pj. No column type is text type. When a text type column stores purely numeric number, the apostrophe indicates that it is a text type field. Please set that column as number type if you do not wish to have the apostrophe.

 

You need to change PJ No. to number, 
To change it you need to go to Data > Columns > select your table that had PJ No. Column, then change the type of your data into Number type

Top Labels in this Space