ChronoEngine.com homepage

Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

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...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
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...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
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?

2020-11-05.png
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...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
You need to login to be able to post a reply.

2Checkout.com

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com