BUG: after syncing the app resulting "text" from expression "UPPER" is converted to "number"

[Asheetbogo]

I noticed strange behavior when converting "text" to "capital lettes"
with expresson "UPPER".

step 1:
e.g: converting "01mai" to "01MAI" (text > to capital letters) 
with expression "UPPER"

step 2:
after saving record everything works fine: "01mai" is converted to "01MAI" 
>>> please notice that there is a sync going on in the background ...

![Asheetbogo_3-1672265017760.png|1084x538](upload://uLXTPf2FVeccc9FNj87fMGrCYyq.png)

step 3:
after syncing the app, suddenly "01MAI" is "converted" to "44682"

![Asheetbogo_4-1672265094769.png|1082x604](upload://lYCskctGnhVyL52DvmTtg2qhHZ5.png)

this only happens with special combinations of "number" + "text":
00mai > 00MAI (correct)
01mai > 44862 (???)
20mai > 44701 (???)
30mai > 44711 (???)
40mai > 40MAI (correct)

please fix this ... 
many thanks in advance!

[dbaum]

It looks like the values are being parsed as dates rather than text–and maybe only on the server (i.e., not the local app). That would explain why numbers outside the range 1-31 don’t get misinterpreted.

So, confirm that your data source has the pertinent columns formatted explicitly as text–otherwise, the automated default could be number or date. For example, in Google Sheets:

If that doesn’t resolve the issue, you could experiment with workarounds. For example:

UPPER(TEXT([Name]))

LEFT([Name], 2) & UPPER(RIGHT([Name], 3))

[Asheetbogo]

hi @dbaum,
thank you very much for your prompt reply,
formatting the column in GoogleSheets from "automatic" to "plain text" 
solved the issue !