Link Related Tables
In this section you will learn how to link related tables for creating a customer portal
You can link different tables as long as there's a common field in both of them. In our case, we'll link by the Unit name
field.
In Jet Admin you can link tables from different Bases
Display the Projects
Drag the Table
component and change the mock data to your own. Select the data source you've connected and the page you want to display:
Drag and Drop the Table Component to the page
Choose the Resource and the Collection
Link the Tables
Each Unit
has many Tasks
and we want to see the list of Tasks
for a given Unit
. To create this flow, follow the steps:
Click on the Table
Click on the
Filter
iconChoose Unit ID -> ID equals
Click on the
Formula
iconChoose Units -> Selected Row -> ID
Now, let's customize our Portal:
Customize your PortalLast updated