I do it like this, using the Xano Connector:
- In the function stack, I do the “Query all records” of the tables I want, in your case 8 queries.
- Each query will return a variable, so in the response I add each of the variables, again, in your case there will be 8 variables in the response.
- I do the search in Xano and copy the response.
- I create a virtual call in the Bubble API Connector plugin and paste this response to configure the variables.
- Then I add the Xano Data element and make the call returning this type of data that I created in step 4.
- In the dropdown, I pull: Xano Data Products: each item’s T-shirts
- In the option caption, you can pull the name of the t-shirt, for example: current option’s name. As long as this is in the response of the t-shirts query.
Does that make sense? Maybe there’s another way to do it, but this is how I do it.