physical vs virtual column App formula calculation

AppSheet AppSheet Q&A
1

NOTE: I have edited this post to correctly state my question

I am trying to figure out why the exact same App formula in both a physical and virtual column do not behave similarly, which implies I am missing something rather fundamental with AS (which scares me :confused: )
The formula is IFS([Table]=“Staff”,COUNT(Staff_raw[Name]),[Table]=“MOS”,COUNT(MOS_raw[Name])), where each row should look at its “Table” column and then go count the number of rows in a different table which matches. The VC is working fine, but nothing shows in the physical, and it is worth noting that testing the formula gives the exact answer expected. What am I missing here?

jharkless_0-1740203485584.png
jharkless_0-1740203485584.png559×167 7.53 KB

jharkless_1-1740203607333.png
jharkless_1-1740203607333.png721×362 18.3 KB

2

Huh? VC’s don’t have “Initial Value” property.

Can you show your view where this is not calculating correctly and the column configuration?

1 Like
3

Yep, that was a complete typo on my part- it is not a VC, but rather a physical column (1st image in original post message).

4

And thus, to your point, when I make it a VC it works!
Shouldn’t have a physical column also worked?

5

Well, after further testing, it appears the answer (pure speculation) is that for a physical column to have data written to it, something has to trigger said write to occur- that could be a form entry, an action, etc.