Hi, I am building a website for teachers association using elementor pro. Every teacher should have his own profile page where he can fill in details as a member about what he teaches, when, where, etc. I want these details from all the teachers to gather automatically to a front end table so whoever is interested can search and filter teachers by the subject of teaching, area of teaching, days and hours, etc. (multiple options)
My question is: does wpData can do that? can it take the info from the teacher's profile automatically meaning that users edit only their own rows in the table from their own page? As example, the teacher will have on his page a small table showing 3-4 classes on different days and locations. This info will be drawn automatically to the general table on the home page of our site so pupils can search and filter classes in hours or locations they are interested in from all the teachers.
You would need to join these tables into one. Since they need to edit these tables, they would need to be manual tables, which are saved in the database.
Then, you would need to create an SQL query-based table, which would join all those tables into one.
Please note that writing custom queries is not included in the provided support for the plugin, so we wouldn't be able to help you with that. You would be able to use our MySQL database query generator, but also note that this tool is not an ultimate query constructor, so you would often need to work on the query it generates.
Hi, I am building a website for teachers association using elementor pro. Every teacher should have his own profile page where he can fill in details as a member about what he teaches, when, where, etc. I want these details from all the teachers to gather automatically to a front end table so whoever is interested can search and filter teachers by the subject of teaching, area of teaching, days and hours, etc. (multiple options)
My question is: does wpData can do that? can it take the info from the teacher's profile automatically meaning that users edit only their own rows in the table from their own page? As example, the teacher will have on his page a small table showing 3-4 classes on different days and locations. This info will be drawn automatically to the general table on the home page of our site so pupils can search and filter classes in hours or locations they are interested in from all the teachers.
Hello yoav aptowizer
Thank you for your interest in the plugin.
You would need to join these tables into one. Since they need to edit these tables, they would need to be manual tables, which are saved in the database.
Then, you would need to create an SQL query-based table, which would join all those tables into one.
Please note that writing custom queries is not included in the provided support for the plugin, so we wouldn't be able to help you with that. You would be able to use our MySQL database query generator, but also note that this tool is not an ultimate query constructor, so you would often need to work on the query it generates.
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