So, I have a few tables that each contain a reference to a central table. Naturally, AppSheet then generates a virtual column in the central table with a reference to the rows in these distributed tables, but what if I donโt want these virtual columns?
I am able to delete them, but as I save and it reloads the app, it generates them again. The extra odd thing is, that I already have some virtual columns that are equal to the ones Appsheet tries to generate, except the name of the column itself is not exactly the same.
I could of course just toggle โShow?โ off, but it feels like Iโm wasting resources/sync time and cluttering the column view more than necessary. Any ideas?
Best regards
Solved! Go to Solution.
There are some tricks you can use to avoid them, but AppSheet really wants them there. Really best to just get used to them.
Note that you can adjust their configurations some. There is a minimum amount of the original config that must occur, else the app editor will recreate it again, but beneath that threshold, you can make changes. For instance, I routinely rename the columns by removing Related
.
There are some tricks you can use to avoid them, but AppSheet really wants them there. Really best to just get used to them.
Note that you can adjust their configurations some. There is a minimum amount of the original config that must occur, else the app editor will recreate it again, but beneath that threshold, you can make changes. For instance, I routinely rename the columns by removing Related
.
I see. Best option is probably just to hide them then
I have hidden them but I see in the Performance Details that it it taking 25 secs to to retrieve/query related column which I donโt really need
You have to really delve further down into it. Automatically created REF_ROWS related columns usually have next to no impact on sync times. Chances are more likely that something else is slowing it down and the related columns are getting blamed because theyโre waiting to finish calculating.
User | Count |
---|---|
62 | |
25 | |
14 | |
11 | |
6 |