001 from table gives 1 in app

[Aktar_As]

Hello,
I have a table with a column X which the app is taking numbers from. The column is 001, but when opened in the app with a text column and a valid if Sheet[Column X] it will show 1 only. Not showing the two 0`s. Tried alot of different stuff, and i managed before… but with same settings it just wont work… Any suggestions?

Thanks!

[Grant_Stead]

Often I’ll just make those text fields…

[MultiTech]

Yup, then you can force it back to a number when you need to do math on it.

NUMBER([Text_Field])
DECIMAL([Text_Field])

[Aktar_As]

I have it in plain text… works on one app but not this one… @MultiTech_Visions where to put those formulas?

[MultiTech]

you use those two formulas in any place that you need to use the number value that stored inside that text column. So inside formulas, math and stuff.

You might need to switch the column type in the second app to text, or at least make sure that all of your apps have the same column type for each column.

in your second app that might be the place where you need to wrap any [column] call with one of those formulas in order to convert the text back into a number so you can do your math.

[Aleksi]

@Aktar_As Would you please take a printscreen so we could be sure what and where that situation is, thanks.

[Aktar_As]

Thanks @MultiTech_Visions . Heres the screenshot @Aleksi

And the app will store it as “1” in the new table.

.

[Aleksi]

Is your value always 3 digits or can it be what ever?

[Aktar_As]

@Aleksi It is Always 3 digit

[Aleksi]

Have you tried to set the digit to 3 for that number column?

[Aktar_As]

Yes i tried that in Gsheet, didnt help. But also tried plain text in gsheet, and text with valid if in the app with information from a different table.

[Aleksi]

Please try it from the app.

[Aktar_As · Accepted solution]

I just made a new Sheet in the GSheet, and copied the information over and used that one instead. Then it worked perfectly again.

Thanks for the suggestions!

Have a nice day