Did you ever get it to do it with a column index? I'm just worried that with two tables and a total of 12 columns on the page, all these conditional data sources will be heavy.
Hi there, thank you for the video! Happy for the new table element, i ran into a challenge and i hope it is ok to post my question here: I am trying to show data grouped (example City's Name), without loosing the ability to calculate data of that type in the following columns (not just simple aggregations). Why i am asking: In the new table element it seems you would have to make costly searches for every column. In Repeating groups you could at least make ONE search for that data for each grouping and row. But you cannot do that in a table. So it is nice for layout reasons, but is very costly in the case you want to show grouped data AND show calculated data. Not an uncommon usecase i believe. If i am missing a solution here, maybe you could make a video on that? Thank you!
We've not tested GroupBy with the new Bubble Table element. The Table element is in beta so if you're experiencing limitations when compared to Repeating Groups we'd suggest sticking with Repeating Groups for now.
The question is: How do you sort by a field that is not in the main table you are setting for the table. For example, I have one data type for say "Subscriptions", and one data type for "quotes". My table's type of content is "Subscriptions", but I want to sort by the amount in the "quotes" that I am also displaying in the table. How would you do that?
You're correct, you can only sort by text and number fields directly on the data type you're using as your table data. A workaround for this is to use a database trigger create a text field for any dynamic data that is attached to your main data type. This way, when your secondary data is updated, your database trigger updates the text field in your primary data.
@@planetnocode Thank you! I really hope they improve the table function. It has been released for something like a year now and I don't see many improvements...
Did you ever get it to do it with a column index? I'm just worried that with two tables and a total of 12 columns on the page, all these conditional data sources will be heavy.
hey thank u for the video tho, but i want to know when i press on it again it doesn't go back to it's original form, how can i do that?
did you find a solution?
Hi there, thank you for the video! Happy for the new table element, i ran into a challenge and i hope it is ok to post my question here:
I am trying to show data grouped (example City's Name), without loosing the ability to calculate data of that type in the following columns (not just simple aggregations). Why i am asking: In the new table element it seems you would have to make costly searches for every column. In Repeating groups you could at least make ONE search for that data for each grouping and row. But you cannot do that in a table. So it is nice for layout reasons, but is very costly in the case you want to show grouped data AND show calculated data. Not an uncommon usecase i believe. If i am missing a solution here, maybe you could make a video on that? Thank you!
We've not tested GroupBy with the new Bubble Table element. The Table element is in beta so if you're experiencing limitations when compared to Repeating Groups we'd suggest sticking with Repeating Groups for now.
The question is: How do you sort by a field that is not in the main table you are setting for the table. For example, I have one data type for say "Subscriptions", and one data type for "quotes". My table's type of content is "Subscriptions", but I want to sort by the amount in the "quotes" that I am also displaying in the table. How would you do that?
You're correct, you can only sort by text and number fields directly on the data type you're using as your table data. A workaround for this is to use a database trigger create a text field for any dynamic data that is attached to your main data type. This way, when your secondary data is updated, your database trigger updates the text field in your primary data.
@@planetnocode Thank you! I really hope they improve the table function. It has been released for something like a year now and I don't see many improvements...