BETA - More computed columns in Glide Big Tables

[Axel_THOMAS]

Hello, I don’t know if it’s a bug or something else since this functionality is in beta, but I activated the “More computed columns in Glide Big Tables” option 2 weeks ago, but without using it, I just wanted to see if some bugs happen. Worked fine till yesterday when I used it to create some new columns. Now some lists don’t load, and I have an “unknown error executing query” (they don’t use the new query).

So I deactivated this functionality, and all works fine, but this would be very helpful, so please let me know if there is a way to use it.

[ThinhDinh]

@Axel_THOMAS Can you explain what do you mean by “used it to create some new columns”? Can you include some screenshots?

[Axel_THOMAS]

There are two big tables used: Project and Project Items. In the Project table, I’ve made a query to get all the rows in Project Items that are related, then made a lookup to retrieve all the dynamic JSON columns. After that, I created another JSON column using the result of the previous lookup. The limitation of 100 rows per lookup is respected.