What is the first code: "0" will be deleted automatically?

[11166]

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

May I ask the return value of the above formula: if it is “0123”
But the first code “0” will be deleted automatically
Only returns “123”
How can I solve it?
Thank you

[Sarvesh_Mudkavi]

I think you have to change the column format to Number

[Aleksi]

If you want to save the value with the leading zero, you need to use column type as “plain text” with your spreadsheet. “Automatic” or “Number” type will filter the zero away when saving the value to your data base.

[11166]

I have set it to “Text” in the “Type” type in APPSHEET

But still not work

Another database source is “MS SQL SERVER” and its Type is set to “VARCHAR (4)”

Is this “Bug”?

Thank you

[Steve]

Please post a screenshot demonstrating the problem.

[11166]

I am elaborating on my question

1. The database that I set is “MS SQL SERVER”, not GOOGLE SHEET

2. There is a CUSTOMER database in 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
   Its information is: 0234 CNAME1
   0678 CNAME2
   0012 CNAME3

3. In APPSHEET, there are three fields of CUSNO and CUSNAME, SCHEDULENO
   Its “Type” is “Text”

4. The “INITIAL VALUE” in the CUSNO field in APPSHEET is set to:
   SELECT (DBO.ORDER_D [CUSNO], [SCHEDULENO] = [_ THISROW]. [SCHEDULENO], TRUE)

5. Enter 0234 in the SCHEDULENO field
   Normal in CUSNO should display: 0234
   But it does show: 234

6. Is it APPSHEET BUG?

Thank you

[Steve]

Please post a screenshot demonstrating the problem.

Please also post screenshots of the CUSNO and SCHEDULENO columns in AppSheet.

[11166]

Source is “ms sql server”
Directly connect to the database and then browse the database directly
, Where the red box is marked:
cusno: 133, the correct value should be: 0133
ordseq: 2, the correct should be: 02
itemno: 133223, the correct value should be: 0133223
Ask the teacher for help
Thank you

[Steve]

AppSheet does not modify Text values upon display, so I would have to assume the value being provided by your database also does not have the leading zero. Can you provide a screenshot of an SQL statement and output showing the stored values?

[11166]

Ask the teacher
As shown in the red line of the attachment: datasource: google
And the blue line: database-1: google

I remember that when I first started, I was transferred from the specified “ms sql server” source?

I do n’t know when it will become a datasource: google

Or did I accidentally press that setting there?

Is there any relevant documentation for this part of the operation?

Thank you

[Steve]

Please contact support@appsheet.com for further help.

[11166]

Thank you very much teacher