So I added a virtual column to one of my tables, had to change the formula around a few times to make it work, but no matter what I tried I could not get the column to return data that I thought should have been included.
I created a new virtual column again and left the other one in place. I then started writing my formula and updated everything and voila the column contained the data that I thought should be included.
As a test, I then copied the โworkingโ formula from the 2nd virtual column to the 1st virtual column and saved&verified data. The 2nd vcolumn still contained the correct data but the 1st one did not even though the formulas are now identical.
Did the 1st vcolumn somehow get corrupted or what is the deal here?
More like loose itโs mind! Haha
Sometimes strange things can get stuck โunder the hoodโ - so to speak.
Iโve had views that had something happen to them where I had to scrap them and start anew; something to do with the โelementโ that represents that thing (that view, column, slice) - the thing that we actually see and interact with on the screen.
These โcontainers,โ or whatever theyโre called, can get some erroneous metadata sometimes - though this is rare.
Hi @Markus_Malessa, so @MultiTech_Visions is a grizzled veteran of many AppSheet years, so heโs giving you pragmatic advice to workaround the occasional oddities of our platform.
But as a part of the AppSheet dev team, I think every one of these things sounds like a bug. So my request is โ please report it anytime something like this happens. If you have an app where there are two identical virtual columns and they produce different values, Iโd love to see it. Because that sure isnโt what is supposed to happen. If AppSheet โloses its memoryโ in that way, Iโm going to โlose my sleepโ to get it fixed :]
The same happens with "Is Part of". Every time I change a property in that table I need to remember to check again "Is Part of" in one of the fields.
User | Count |
---|---|
45 | |
27 | |
27 | |
21 | |
13 |