A text field with the setting "number" is not a number

[uk141]

I created a text field, set the "number" in the settings, not the text. I enter the letters in the field and they disappear, I enter the numbers and they remain.
I try to enter data from a field into a table using Patch, but I get an error that "2234" is not a number!
I created a text field with the formula

If (IsNumeric (TextInput5_5); "Numeric!"; "Is not")

and the field also shows that this is not a number.

How can this be? Have I missed the setup somewhere?

[SeanHenderson]

Hi,

Try:

If(IsNumeric(Textinput5_5.Text), "Numeric!", "Is not")

---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

[uk141]

This works for a text field, but not for entering into the database. After checking it shows that this is a number, but nevertheless, when I enter it, I get an error due to the fact that 1, this is not an error.

I enter the bash using the function

 Patch (
        Table1_1;
        Defaults (Table1_1);
        {
            Format: Dropdown1.Selected.Formats;
            Order: Value (TextInput5.Text);
            'Stream-eat': TextInput5_1.Text;
            Code: TextInput5_2.Text;
            Marked: Value (TextInput5_3.Text);
            Deleted: Value (TextInput5_4.Text);
            Gluing: Value (TextInput5_5.Text);
            Domotano: Value (TextInput5_6.Text);
            Surname: Surname;
            Start: DateTimeValue (DatePickerS.SelectedDate & "" & StartTimeH.Text & ":" & StartTimeM.Text);
            Stop: DateTimeValue (DatePickerF.SelectedDate & "" & FinH & ":" & FinM);
            Report: templatename
        }
    ) ;;

And in the remaining fields he likes everything, in the remaining numbers and without problems, but here are some mistakes.

[uk141]

Here is a picture. Ignore the empty fields, they are cleared after entering.

[SeanHenderson]

For which field is it expecting a number and getting the error? What data type is that field in your data source?

[uk141]

Field textinput5_5. Gluing.
The number is in the field settings, the number is in the table properties, I will pass the number, but for some reason the table is not passed a number.

[SeanHenderson]

What is the data source? CDS? SQL Server? SharePoint?

In the data source, what is the data type for the Gluing field set to?

[uk141]

excel table in sharepoint.

[SeanHenderson]

In your SharePoint list, what is the data type for the Gluing column?

[uk141]

Is number