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.
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?
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |