Does GOOGLE SHEET FORMAT have "Plain Text"

Does GOOGLE SHEET FORMAT have “Plain Text”
Why is the type of APPSHEET only “Text”?
And when the first code is zero when it is archived, it will be deleted
Thank you

The formatting of your Google Sheet is separate from the the data types used in AppSheet. AppSheet does try to guess the appropriate data type based on the data in the column or by the name of the column header. For example, column headers with a “?” are usually set as a “Yes/No” data type within AppSheet.

Yes, Google Sheets have a “Plain Text” option. See the image below.

AppSheet has Text and LongText data types, that’s all that is needed for text values, it represents ALL of the Google sheet column types AND has many of its own data types. See articles below.

If you are wanting to retain leading zeros in your data then that does mean you want the value treated as Text and not a Number. Set the column in your Google Sheet as “Plain Text” and set the column in AppSheet as Text.

If later, in AppSheet you want to treat this text as a number, for instance to add 1 to the value to get the next sequential text value, you can use the NUMBER() function which will temporarily treat the value as a number.

5 Likes

Thank you, teacher

Please also ask the teacher when my database source is “ms sql server”

Its structure is:

CREATE TABLE dbo.CUSTOMER

(

CUSNO VARCHAR (5) NOT NULL,

CUSNAME VARCHAR (100) NULL,

SCHEDULENO VARCHAR (50) NULL,

PRIMARY KEY (CUSNO)

)

END

I wonder if the teacher has tested it?

The “initial value” in the CUSNO field of APPSHEET is set to:

SELECT (DBO.ORDER_D [CUSNO], [SCHEDULENO] = [_ THISROW]. [SCHEDULENO], TRUE)

The correct cusno should be: 0123

But the appsheet response is indeed: 123

Ask the teacher for help

Thank you

You asked about Google Sheets, then switched to SQL. What is your actual problem?

1 Like