Why virtual colum cell changes data after few seconds ?

[kvngo94]

Hey guys,

Notice the consumption, after update row, it turns below value, it's correct

But after like 3 seconds, it turns to another 2nd value as below

Could you advise what makes it automatically change to another value after few seconds ?

[diogolupcosta]

Maybe something is changing some value in their expression

[SkrOYC]

You have to share your expression and any column config related to that expression for us to help

[kvngo94]

Hi SkrOYC, 

Please kindly advise, please refer below my set up :

1.  

2.  Expression :

3. It relates to MATERIAL TYPE, UNIT, SPEC

[kvngo94]

Hi SkrOYC, 

Do you think the problem is with the "NUMBER(EXTRACT("NUMBERS",[SPEC]))" line in my expression

It seems return correct value at first but after few seconds it changes to another value. I put it like this because in SPEC sometimes it's not number or decimal value, but it's text value like 58 inch, and I want to get the number 58 only to  calculate

[kvngo94]

Hi SkrOYC, 

I just updated my formula as below, but it's too long, could you advise anyway to reduce the length of it ?

[Steve]

The behavior you're seeing, where a virtual column changes after a few seconds, typically occurs when the virtual column is recomputed during a sync. When a sync occurs all virtual columns are recomputed by the AppSheet server. The server will have access to the most current data, including data from other users, that may not have been available on your device when the virtual column value was first computed. That broader set of data available to the server may prompt your expression to produce a different result.

Your expression is very complex and difficult for me to interpret. Could you please cut and paste the entire expression (the text, nit a screenshot) into a reply? I would like to see if I can restructure it to help clarify it for me, and to see if I can find why might be causing your problem.