for example when viewing a list of records, if there is a separate joining table we could select to add a field in the list for that joining table for example
Contacts Table/Module
Contact Emails Joining Table/Module
in the Contacts “Record List” block we add a custom field that can either be a Count of the joining table filtered for that Contact or we could apply a filter to that joining table to select what field / item is displayed
in the email example lets assume the “contact emails” module has contact record selector, Email Field, IsWork Bool Field, isPrimary Bool Field, isVerified Bool Field, CreatedDate Field
then when selecting the single display option you could filter for iswork = true is primary = true and have a default sort by latest created and then you select the Email as the field to display in the list
This record field would be linkable in 2 ways if the underlying field selected to display is a linkable field i.e. Email input or URL input then in the record list is in shows its default linkable state if it is not then it is still linkable but pops out the modal for that sub joining table is displays count of 3 emails user clicks on it and modal opens up of the 3 emails for that contact.