I have a text-based website design that I'd like to build without coding, using suitable software.
I would build web pages using Wordpress and Elementor.
The key metadata would reside in a single-table database.
The data on the main web pages would be pulled by querying the database.
On each resulting record, several fields would be displayed on a main web page: - an article title - the reading time in minutes - one or more long tags that have the attribute TRUE from a large, fixed list of tags
Each record would be displayed on a main web page with these field values stacked vertically all in a single column.
Each field would be independently formatted.
The next record would be displayed below the previous record, all in the same single column.
The formatting that separates each record from the next record could be formatted.
This readily be accomplished with a printed report using Microsoft Access.
Can this be done using wpDataTables Premium?
If not, then I'd appreciate any suggestions for how best to do this.
Thanks in advance for considering this problem specification!
The outcome depends less on the way the data is saved in the database, but more on how much you're familiar with SQL queries.
If you know your way around queries, you will have no issues creating a table that will display data in that way. If you have your database ready, you can connect it to our sandbox website, and test it all out before purchase.
To see how you can connect the database, please check our documentation.
I have a text-based website design that I'd like to build without coding, using suitable software.
I would build web pages using Wordpress and Elementor.
The key metadata would reside in a single-table database.
The data on the main web pages would be pulled by querying the database.
On each resulting record, several fields would be displayed on a main web page:
- an article title
- the reading time in minutes
- one or more long tags that have the attribute TRUE from a large, fixed list of tags
Each record would be displayed on a main web page with these field values stacked vertically all in a single column.
Each field would be independently formatted.
The next record would be displayed below the previous record, all in the same single column.
The formatting that separates each record from the next record could be formatted.
This readily be accomplished with a printed report using Microsoft Access.
Can this be done using wpDataTables Premium?
If not, then I'd appreciate any suggestions for how best to do this.
Thanks in advance for considering this problem specification!
Attached is the structure of the single-table database.
Hello James
Thank you for your interest in wpDataTables.
The outcome depends less on the way the data is saved in the database, but more on how much you're familiar with SQL queries.
If you know your way around queries, you will have no issues creating a table that will display data in that way. If you have your database ready, you can connect it to our sandbox website, and test it all out before purchase.
To see how you can connect the database, please check our documentation.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables