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
35 stars 11 forks source link

Table module #63

Closed Paradontix closed 7 months ago

Paradontix commented 9 months ago

I love how easy it is to create tables with the plugin and it can be simply adapted. The only complaint that I have is that I want to be able to embed a table into an article on my joomla site. This would be easy when a module exists that can be loaded into an article. Maybe I am not aware how to achieve this easily.

Describe the solution you'd like A solution I'd like is to have a module. That like the menu page can be added to any article I like.

Describe alternatives you've considered My current workaround is to have a wrapper module that wraps the menu site into a module that can be loaded into the article. This is not optimal because it doubles the header and menu.

joomlaboat commented 9 months ago

Hello Paradontix,

You can use this module: https://joomlaboat.com/custom-tables-module

Or a plugin (Pro version) https://joomlaboat.com/custom-tables-plugin

Plugin use example, you can use it from any article or whatever:

{customtablescatalog=TableName,PageLayoutName}}

or

{customtablescatalog=TableName,PageLayoutName,PageItemName,ShowPublished,Filter,OrderBy}}

PageItemName is optional

ShowPublished values: showpublished,showunpublished,showany

Filter example: "company=1"

OrderBy: field name to order by

{customtablescatalog=product,ProductsCatalog,,showany,price>0}}

balk77 commented 6 days ago

@joomlaboat , replying here because I think it's related.

It is unclear to me if these table modules allow me to create a input form table, a bit like Excel. Updating a field would execute (on change) a query in the custom table. The table I have for my use case is dynamic in size. If possible, would you care to share some screenshots? Thanks 🙏

joomlaboat commented 5 days ago

@joomlaboat , replying here because I think it's related.

It is unclear to me if these table modules allow me to create a input form table, a bit like Excel. Updating a field would execute (on change) a query in the custom table. The table I have for my use case is dynamic in size. If possible, would you care to share some screenshots? Thanks 🙏

Hello Balk77, yes you can create a table add columns (field) assign types: text, number, date etc. Then you can create a custom layout and output it in the front-end.

https://joomlaboat.com/custom-tables-wiki