I need to develop an course site for registration per course (dates) and for each course I will have several teachers assigned to participant.
List of participants willl be fetched from registration table. Super user will have them listed and then he can assign each participant to his/her teacher. Always can update if needed. Also super user can click on the teacher itself and get listed all the participants for that course.
Bottom line:
1. How to GET an drop down field of the teachers in EDITABLE row of the shown table and then UPDATE of that row will hold ID of the chosen teacher from the drop down?
2. How to get a CLICKABLE value in the row field (teacher) which after superuser click on it then it redirects to a new table to show all the participants assigned to that single teacher?
Glad to hear that you find solution for the first question.
If you will have table with all the users and all the participants in it you can just filter the table by teacher and it will show all participants for that user. If you plan to have more than one table than you can use filtering through URL option which will allow you to filter table on page where second table is. You can find more information about this feature in our - Documentation. Basically you need to have URL column - Documentation in which you will have teachers and links to the second table which will contain filter through url part and will automatically filter second table by teacher whose name is added to url:
Furthermore, I need all of that to be filtered based on the COURSE which is on specific dates. For that course participants will apply via frontend form (allowing wordpress to store the user details).
Can we talk about that on Croatian (I assume we can understand).
This field is editable. It means that when user wants to add new line (new student and related info) and when Hometown need to be inserted on the popup window I cant get an values to select based on the foreign key table related.
Ok I changed in the editable column to 'single value selectbox' which now gives what i want.
However, since my towns are from different countries. How to SHOW not only the town (field from related table) but also TOWN and COUNTRY from the same table? Only in the popup list... In the table it is showned already as a two columns...
select polaznikid, sifra , ime , prezime, godinarodjenja, email , mobitel , g.gradid, CONCAT(grad, ", ",drzava) grad, s.spolid, spol from dvPolaznici p inner join dvGradovi g on p.gradid = g.gradid inner join dvSpol s on p.spolid = s.spolid
and i created as said - editable fields GRAD and SPOL with their data and related id keys. In popup EDIT or INSERT NEW row I got this error message as you can see in the screenshot. How to accomplish given?
Because you brought the plugin, please open a ticket in wpDataTables category with your purchase code and one of our support agents will provide you help with your issue.
I need to develop an course site for registration per course (dates) and for each course I will have several teachers assigned to participant.
List of participants willl be fetched from registration table. Super user will have them listed and then he can assign each participant to his/her teacher. Always can update if needed. Also super user can click on the teacher itself and get listed all the participants for that course.
Bottom line:
1. How to GET an drop down field of the teachers in EDITABLE row of the shown table and then UPDATE of that row will hold ID of the chosen teacher from the drop down?
2. How to get a CLICKABLE value in the row field (teacher) which after superuser click on it then it redirects to a new table to show all the participants assigned to that single teacher?
I just found on your demo that question 1 is solved :)
Hi Elvis,
Thank you for your inquire.
Glad to hear that you find solution for the first question.
If you will have table with all the users and all the participants in it you can just filter the table by teacher and it will show all participants for that user. If you plan to have more than one table than you can use filtering through URL option which will allow you to filter table on page where second table is. You can find more information about this feature in our - Documentation. Basically you need to have URL column - Documentation in which you will have teachers and links to the second table which will contain filter through url part and will automatically filter second table by teacher whose name is added to url:
https://yoursite.com/link_to_second_table?wdt_column_filter[0]=TeacherName||TeacherName
Thanks,
Furthermore, I need all of that to be filtered based on the COURSE which is on specific dates. For that course participants will apply via frontend form (allowing wordpress to store the user details).
Can we talk about that on Croatian (I assume we can understand).
Hi,
I finally started on my project for which I bought your app.
I havea issue. I am showing data from one table and based on the id I show also data from another table (town).
https://wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/
This field is editable. It means that when user wants to add new line (new student and related info) and when Hometown need to be inserted on the popup window I cant get an values to select based on the foreign key table related.
Ok I changed in the editable column to 'single value selectbox' which now gives what i want.
However, since my towns are from different countries. How to SHOW not only the town (field from related table) but also TOWN and COUNTRY from the same table? Only in the popup list... In the table it is showned already as a two columns...
Ok i understand :) I will use the VIEW
Now I have real issue.
I am using this for the table:
select polaznikid, sifra ,
ime ,
prezime,
godinarodjenja, email ,
mobitel , g.gradid,
CONCAT(grad, ", ",drzava) grad, s.spolid, spol
from dvPolaznici p
inner join dvGradovi g
on p.gradid = g.gradid
inner join dvSpol s
on p.spolid = s.spolid
and i created as said - editable fields GRAD and SPOL with their data and related id keys. In popup EDIT or INSERT NEW row I got this error message as you can see in the screenshot. How to accomplish given?
Hi Elvis,
Thank you for the purchase.
Because you brought the plugin, please open a ticket in wpDataTables category with your purchase code and one of our support agents will provide you help with your issue.