I do it like this, using the Xano Connector:

  1. In the function stack, I do the “Query all records” of the tables I want, in your case 8 queries.
  2. 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.
  3. I do the search in Xano and copy the response.
  4. I create a virtual call in the Bubble API Connector plugin and paste this response to configure the variables.
  5. Then I add the Xano Data element and make the call returning this type of data that I created in step 4.
  6. In the dropdown, I pull: Xano Data Products: each item’s T-shirts
  7. 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.