Summary: I would like to display all the products a vendor has available when the vendor is selected from a repeating group.
I have vendor names in the repeating group as a part of my “home” page. For each vendor, there is a list of products from a different ‘product’ table which I have linked to the ‘vendor’ table.
Dataflow: When a vendor is clicked, I am navigating to a new page called “vendor_test” to display all of the products of the selected vendor from “home”. I have built the workflow to go to the “vendor_test” page, sending a parameter key I’ve named vendor_v1 which stores the parent group vendor’s company’s name.
In the “vendor_test” page, I have a repeating group with Type of Content ‘vendor’ and Data Source ‘search for vendor: first item’ with the company name set to the parameter key vendor_v1 I created to return the chosen vendor from “home”.
Problem: The piece I need help is with listing all of the products of this chosen vendor. Currently, I’ve managed to only pull the first item of the vendor, or list all the vendor’s items in the same repeating group’s group, separated by commas. How would I individually display all of the items that vendor has in the products table? I’m open to trying a different method if the RG is not the way.
I’m new to linking data between different tables to create lists. Any best practices here or links to documentation would be appreciated! Currently, I’m using this page as guidance.
Instead of listing the products for the vendor ‘HON’ in the same repeating group’s group, I would like to separate the gloves and goggles into different sections of the repeating group.
After tinkering with it some more, I’ve learned sending the parameters from the page URL won’t work for vendors with more than 1 product in their list so I’ve ruled out that possibility. Ultimately, I will navigate from the listed products into a single product details page.
Instead of passing the company in the url, you could make the Type of content of your vendor_test page = Vendor. Then when you navigate to that page you will be prompted to send a vendor with the navigation and you can send the vendor that is clicked on your home page.
Then on the vendor_test page change your repeating group Type of content to Products. The Data source would be Current page vendor’s products. Now each cell of the repeating group should be an individual product and you can display whatever you need for that product (ie. name, image) in the cell.
