joomlaboat / custom-tables

The Custom Tables extension allows you to create, manage, and display custom data on your Joomla site. It is helpful if you need to display data that is not part of the standard Joomla content structure. For example, you could use this extension to create a custom table for product information, customer data, or any other type of data that you need to display on your site. The Custom Tables is the CRUD solution for Joomla 3.x and 4.x - CREATE, READ, UPDATE and DELETE. You can add tables, fields, and layouts to create catalogs, forms, or details pages. It has 40 Field Types: Integer (numbers), Decimal, Text String, Time, Email, Color, Image, File, User, Language, etc.
https://joomlaboat.com/custom-tables
GNU General Public License v2.0
36 stars 11 forks source link

Add ability to join "standard" tables #26

Closed mc-cm closed 2 years ago

mc-cm commented 2 years ago

Hello! I'd need to create a directory of locations and "connect" contact information to it. Custom tables will do the location directory quite fine! Thanks for that. But all the contact entries I already have in my com_contact tables / component. So, it would be a perfect thing if I just could join data from com_contacts to the custom table location directory. As detail: some contacts have different roles at different locations; so I'd need several fields to add contact data, for example:

Maybe I'm not die only one who would find it helpful to have access to other tables (articles / contacts). Thanks a lot!

joomlaboat commented 2 years ago

Hello,

image

Its very easy, just select Third-party table in Advanced tab, and type the name of the Primary Key field. You will be able to access all fields and records of that table in the same way like with Custom Tables: {{ name }}, {{ position }}

Regards, Ivan