Forums

Multiple Tables

rafaelscouto 28 Oct, 2020
Hello guys, I have a question.

I have a database (ex. Cars). I would like to display 4 tables, separated by brand (eg Ford, GM, Tesla, Porshe).

Tab Ford
id, name, model ...

GM Tab
id, name, model ...

Tesla Tab
id, name, model ...

Tab Porshe
id, name, model ...

I would like to create a button where I could choose which of the tables to display according to the selected brand.

I believe there is a better way to do it, like a single table and make this select, but I don't know how to do it.
Max_admin 02 Nov, 2020
Hi Rafael,

What about trying v7:
https://www.youtube.com/watch?v=raXqQcU_OB8&list=PLNdPw6Bog3zcuSKs7NGNi8QPtfj5IsxQA&index=10

Then you will need add a dropdown field above the table list, open the dropdown settings, go under Behaviors > Data then select "Filter Listing", choose the data source as in the video and set the Model Field to the table field with the Car brand, your dropdown options values should match the values of the table field!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
rafaelscouto 04 Nov, 2020
[font]Is there anything left to do?

on the front when I select the item in the dropdown nothing happens[/font][file=13473]Capturas_de_tela.zip[/file]
images in the zip
Max_admin 05 Nov, 2020
Did you setup the dropdown filter behavior ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
rafaelscouto 05 Nov, 2020
I have this situation:

A table of articles, I want that when selecting the category, only the items of that particular category are displayed, according to the images attached.

Remembering that the dropdown values are the same as the categories.

I have some doubts, do I need to add some where in the "read_data"?

Because if I'm not mistaken, at CC I needed to do that.

At CC I also used a submit button, don't you need this new CF7? Just select the item that it already reloads automatically?


Max_admin 10 Nov, 2020
Answer
your setup is good, you just need to have a button with the dropdown, change the dropdown to 20 then click the button to submit the form, does it filter the list or not ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
You need to login to be able to post a reply.