Virtual column value different in tableview and form

AppSheet AppSheet Q&A
1

Hello,

I have a table “Parts” where the key [REF] is a numerical value. I use a virtual column to format my ref as xxx-xxx-xxxx with this formula : mid(number([REF])+10000000000,2,3) & “-” & mid(number([REF])+10000000000,5,3)“-” & right(number([REF])+10000000000,4).

In a table view, the value is “–6789” but in form view or when i test my formula i have “012-345-6789”

Where is the problem ?

thx for all

2

Ok, I finally find the problem, this is the function mid(). I rewrote the formula as this :

mid(“”&([REF]+10000000000),2,3) & “-” & mid(“”&([REF]+10000000000),5,3) & “-” & right([REF]+10000000000,4)