AppSheet insists on generating virtual column after deletion of these

Viktor
Participant V

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?


Here is an example. Iโ€™ve highlighted the columns that are identical (except for the name). Interestingly enough it also only does it for 2 of the 5 tables that contain a reference to this table.

Best regards

Solved Solved
0 4 323
1 ACCEPTED SOLUTION

Steve
Participant V

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 .

View solution in original post

4 REPLIES 4

Steve
Participant V

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.

Top Labels in this Space