I set the expression
Mid([Project Name], 5, 2)
to the value of column โTestโ, when I filled the value โ12345678โ to [Project Name], the value of [Test] should be โ56โ, but in fact the value of [Test ] is โ34โ,
Can someone help to check?
MID(some-text, begin-at, how-many)
Hi @Chengzhi-EXT_GUO, Could you please try to save the record and then check the result?
My testing showed that after saving the record, the expression does return correct result of
โ56โ or 5th and 6th character,in the detail view. However till the record save operation is complete or even afterwards, it returns โ34โ
or 3rd and 4th character in the form view.
I will request senior community members and +Steve Coile for more guidance on reason behind returning 3rd and 4th character before and after save operation in form view.
Hi @Chengzhi-EXT_GUO,One correction, my testing observation was with a VC
having expression. With a real column, your observation is correct. The expression returns 3 and 4 character even in detail view.
Will request +Steve Coileโs further guidance.
Sounds like a bug. Please report to support@appsheet.com.
This behavior seems like a bug. I will investigate.
@Suvrutt_Gurjar @HarryJust done the test, set two column value to same expression, Mid([Project Name], 5, 2)
Below is the result.
In detail view,
Real Column,
34
โ
wrong
Virtual Column,
56 โ
correct
In form view,
Real Column,
34
โ
wrong
Virtual Column,
34
โ
correct
Virtual columns are computed by server, while real columns are computed by the client (device, or browser). The incorrect output in the real columns thus points to a problem in how the expression MID() is computed in the client.
Iโm adding @Adam_Stone_AppSheet, our client-side expert, to investigate further.
A fix for this should be deployed later this week.
@Harry can you clarify your statement that virtual columns are computed on the server, not on the client? How do virtual columns work when the app is offline, then?
+Steve Coile Most expressions are computed in the client (device/browser). This is why things like Show_If, Valid_If, Initial Value, App Formulas, etc. can be computed without syncing (think of how these are computed when the app user is filling out a form).
Virtual columns on the other hand are only computed in the server. If the app is offline, the value of a virtual column will default to โsync to computeโ.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |