Displaying Content from a database in a table.

Ask the community
,
1

I am creating a real estate platform and I want to create listing features of a home in a table.
How do I build my databases so that the information in the table will show in a user friendly way and not listed all in seperate rows?

1013×263 26.9 KB

This is an example from a site that i liked.

To do this would I have to create the database?

Would I have to create multiple databases and then connect them somehow?

2

Hi!
Yes, the easiest way to do your task create Collection with data CMS (Formerly Content Manager): About Your Collection Fields | Help Center | Wix.com , create and connect Dataset CMS: About Connecting Page Elements to Collection Content | Help Center | Wix.com, add Table and connect it to Dataset Working with the Connect Table Panel | Help Center | Wix.com . Note there are option for Table to tune its view using Table Layout . And I think some connection between collections (databases) will be provided soon, in any case now you can get data from any collection using wix-data API https://www.wix.com/code/reference/wix-data.html

3

Ok i understand but but how would that work with dynamic pages. This chart needs to be on a dynamic page with the features and amenities of that specific property. so again I dont understand how that would work?

4

There is some explanation how to manipulate with Dynamic pages CMS: Examples of Dynamic Pages | Help Center | Wix.com (all about Dynamic pages https://support.wix.com/en/wix-code/dynamic-pages) . For your example you can do dynamic page for each features and amenities separately or by group, provide filters by features and amenities e.g. by connection with appropriately filtered DataSets linked to the same collection but with different filter applied to added Buttons, partially this video can help with filter definition https://www.wix.com/code/home/videos . In addition other ways are possible as well to organize your data, using code and/or Next /Previous buttons CMS (Formerly Content Manager): Displaying Collection Content on a Regular Page | Help Center | Wix.com

5

hi,
I need to call dynamic page after table row selection through code .
can anyone please me .
Existing code :

export function searchButton_onClick(event) {
wixData.query(‘CaterersQuatation’)
.eq(‘orderNumber’, $w(‘#textInput1’).value)
.find()
.then(res => {
$w(‘#table1’).rows = res.items;
});
}

6

Hi Anatu,
Answered in this thread:

It is recommended to post a question in a new thread.
Roi.