Multiple Tables

Filter a table listing by category using a dropdown.

Overview

The user wants to display specific data from a single table based on a selection, but the dropdown filter does not initially trigger an update.
Add a submit button to the form containing the dropdown. Ensure the dropdown's filter behavior is configured to match the table's data field, then use the button to apply the filter and refresh the listing.

Answered
Connectivity v6
ra 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 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.
ra 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 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.
ra 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?

Multiple Tables image 1
Max_admin 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.
This topic is locked and no more replies can be posted.