search

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

sqljoin in dropdown with two fields from the other table? #37

Closed mennoswaak closed 1 year ago

mennoswaak commented 1 year ago

Hello

in a table I have Table Join. Is it possible to make in the dropdown list the value of two fields from the other table visible? Field one: integer, field two: string and to save only the content of field one. The part with field one is working very well, but I can't find no way to add the second field. How to do this? Tanks in advance.

Best to know: I am making nice applications with Custom Tables. It is very promising. kind regards menno

joomlaboat commented 1 year ago

I will add this option.

It will be a part of the edit parameters {{ fieldname.edit(Params) }}

I would like to see the application you are making.

mennoswaak commented 1 year ago

The application I'm making now is an exercise. It contains a lot of personal information and is not suitable for showing. But the next application will be. It is for a non-profit educational organisation. And the main part of the content will come from Custom Tables. I will send you a link when it is ready.

joomlaboat commented 1 year ago

Hello Menno, the option to control the dropdown list titles is added to 2.9.8 version.

Example: {{ join.edit("","",[],"myCustomTitle") }}

Where "myCustomTitle" is the layout name to render the titles.

image

mennoswaak commented 1 year ago

Thanks Ivan it is working