A joined list combines records from two or more lists into a single record based on a relationship. This allows you to select fields from all joined lists. Joined lists can join together lists from the same system, or two or more disparate systems using a unique identifier. In this example, you will join Invoice Header information to the Invoice Lines from the Sample Data Connector.
1. Select Connectors from the left navigation to open the Connectors page.
2. Click the Edit icon next to the connector you would like the joined list to show up under. In this example, it will be the Sample Data Connector.
3. From the left navigation pane, select Lists.
4. Scroll down to the Custom Lists section and select Joined: Click here to add a custom list that joins multiple lists. If you have already created custom lists for the connector, you will see your custom lists here. If you already have custom lists, select Add custom list.
5. Give the list a Name and fill out the Item name and Item singular fields. In this example, the name of the list is Join List and for the Item name and singular are Invoice Lines and Invoice Line. If you have created groups in your connector, you will also have a Group dropdown to choose which group you would like the list to appear in.
6. From the left settings pane, select Lists.
7. Select Click here to add a list.
8. Select Sample data from the Connector dropdown and then select Invoices from the List dropdown. Select Save in the Add List window.
9. The first list has been added. Next, you will add the second list and select the fields you will be joining together. Select Add List in the upper right corner.
10. Choose the Connector and List you will be joining. Next select the list that you are joining it with from the Link to list dropdown.
In this example, you will select Sample data from the Connector dropdown, Invoice line items from the List dropdown, and Invoices from the Link to list dropdown. The next two dropdown options identify the unique identifiers/fields you are joining together in both lists. In this example, the From field is Invoice Number and the To field is also Invoice Number. Once all drop downs are completed, select Save.
11. Select the arrow between the two lists. This opens the Edit Join menu on the right-hand pane. Select Left Outer from the Join type dropdown.
12. Select the Invoices box. This opens the Edit List menu in the right-hand pane. Choose Customer Number, Customer Name, Invoice Date, Invoice Number, and Total from the Fields list.
13. Select the Invoice Line Items box. This will change the context of the Edit List menu in the right-hand pane. Choose Item Name, Item Number, and Quantity from the Fields menu.
14. From the left Settings menu, select Fields.
15. Locate the Default fields section and select Show to the right of section. Then select Click here to add default fields.
16. Select all of the fields and then select Add.
17. The list is now available to use in Popdock. To view the list, return to the Popdock homepage and then select Add new tab in the top center of the page.
18. Select Find by Connector. Select Sample data from the Connector dropdown and select Join List from the List dropdown menu. Once those two fields are populated, select Add.
19. The join list will open as a new tab.
Questions on creating a joined list? Email support at support@eonesolutions.com