I want to move them to wpDataTables but I have the doubt if the link queries I've got will work. Please click in "Cert" in my tables in order the see the query that I mean (they query to another sheet in the same Google Sheet file).
Unfortunately I don't have too much experience with this functionality so I can't unsware you straight if this is possible but, for situation like this, we have sandbox website where you can see and test all plugin functionalities
sandbox.wpdatatables.com
username: demo
password: demo
Another possibility whould be to share spreadsheet with me (you can do this here privately) and I will test it for you
Please find more information about creating tables from Google Spreadsheet in our - Documentation
I successfully created a table but Cert link doesn't work. Google export them as plain string (Attachment).
I copied data from your spreadsheet into mine so I can further test it and removed HYPERLINK tag from the first cell in CAREER column (Attachment 2). How when you click on the link you will get result as in Attachment 3.
You have option to rename links in our plugin to show "Certs" instead of link itself - Documentation
I don't see the URL of Attachment 3 but it seems to be the Google Sheet one. That is exactly what I want to avoid, I want to show all the data in my website URL.
I had forgotten to make visible the sheet where the cert data are stored. I've made it now visible to you. It is the last sheet with name "." (a dot).
I have no problem to require to edit my links in your plugin in order to make it work, but I need that all the data will be showed with my website URL (instead of Google).
You will need to create separate tables for all links and then place it on separate pages. That way when someone click on the link in the main page it will redirect him to other page with second table.
This second option will be possible but keep in mind that you need to create two tables (each for every google spreadsheet) and then create as many tables as you need by querying table created from "." sheet. Here you will need to proceed as in first paragraph. Place those tables on separate pages and link them in main table.
My second option is moving from Google Sheets to a new MySQL (not the Wordpress one, but a new one for my Cert Holders database). And call that new database from your wordpress plugin. Does it make sense?
Hi Miljko, as I understand your answer, it is not possible to query.
I mean, you suggest me to create a separate table for the result of the queries and then link them. But that is just because it is not possible to query. Isn't it?
The problem is that currently I've got a single table with all certification earned by students. When I click in the "Certs" link is just queries all the certs earned by that student. I've got hundreds of students. So, I can't build a separate table for the certification of each student. That is not viable.
So, in case it is not possible yo query, your plugin doesn't solve my problem.
Our plugin could not dynamically create a new table. You can create a table from query but not create another table by clicking on the link in the previous one.
Maybe you could create two tables. One will be the main tables with a link and other will be the table with student data. You can then place the student table on separate page and use "Defining filter values in the URL" option to pass student data as filter values to that page. When user click on the link in main table it will redirect it to the page with students table and apply filter defined in URL
In fact, I would like to remove all those options about ("Show n entries", "Print", "Excel", "CSV", "Copy", "Search") that is shown your tutorial video (minute 2) when you published table in Wordpress. I would like to show only the table.
Hi, I sent you a ticket previously but you didn't answer me.
I've got these Google Sheets tables:
https://projectmanagers.org/cert-holders/usa-canada/
I want to move them to wpDataTables but I have the doubt if the link queries I've got will work. Please click in "Cert" in my tables in order the see the query that I mean (they query to another sheet in the same Google Sheet file).
Can I do this with your plugin?
All the best,
Angel
Hi Angel,
Thank you for your inquire.
Unfortunately I don't have too much experience with this functionality so I can't unsware you straight if this is possible but, for situation like this, we have sandbox website where you can see and test all plugin functionalities
sandbox.wpdatatables.com
username: demo
password: demo
Another possibility whould be to share spreadsheet with me (you can do this here privately) and I will test it for you
Please find more information about creating tables from Google Spreadsheet in our - Documentation
Hi Miljko, please give me your google username and I will share a copy of my Google Spreadsheet with you.
It is better this way, because you will know better than me how does wpDataTables work.
All the best,
Angel
Hi Angel,
Please share it to email which you can find in my signiture. Also publish your spreadshhet first
Done!
Please, check if you have received a notification.
Hi Angel,
I successfully created a table but Cert link doesn't work. Google export them as plain string (Attachment).
I copied data from your spreadsheet into mine so I can further test it and removed HYPERLINK tag from the first cell in CAREER column (Attachment 2). How when you click on the link you will get result as in Attachment 3.
You have option to rename links in our plugin to show "Certs" instead of link itself - Documentation
Hi Miljko,
I don't see the URL of Attachment 3 but it seems to be the Google Sheet one. That is exactly what I want to avoid, I want to show all the data in my website URL.
I had forgotten to make visible the sheet where the cert data are stored. I've made it now visible to you. It is the last sheet with name "." (a dot).
I have no problem to require to edit my links in your plugin in order to make it work, but I need that all the data will be showed with my website URL (instead of Google).
Is that possible?
Another option:
1.- Create a new MySQL database (different from the WP database)
2.- Import data from my Google Sheet
3.- Adapt my query links (as they get not imported correctly)
4.- Build the Certs query links by quering the new MySQL database.
Is possible to make something like that? (I am not an expert on databases)
Would be possible you build this for me? (I would pay this service to you)
Hi Angel,
You will need to create separate tables for all links and then place it on separate pages. That way when someone click on the link in the main page it will redirect him to other page with second table.
This second option will be possible but keep in mind that you need to create two tables (each for every google spreadsheet) and then create as many tables as you need by querying table created from "." sheet. Here you will need to proceed as in first paragraph. Place those tables on separate pages and link them in main table.
My second option is moving from Google Sheets to a new MySQL (not the Wordpress one, but a new one for my Cert Holders database). And call that new database from your wordpress plugin. Does it make sense?
Hi Angel,
We do have option to connect to external database from our plugin. You can find that option on Settings page
Hi Miljko, as I understand your answer, it is not possible to query.
I mean, you suggest me to create a separate table for the result of the queries and then link them. But that is just because it is not possible to query. Isn't it?
The problem is that currently I've got a single table with all certification earned by students. When I click in the "Certs" link is just queries all the certs earned by that student. I've got hundreds of students. So, I can't build a separate table for the certification of each student. That is not viable.
So, in case it is not possible yo query, your plugin doesn't solve my problem.
HI Angel,
Our plugin could not dynamically create a new table. You can create a table from query but not create another table by clicking on the link in the previous one.
OK, and how can I apply your "create a table from query" option for showing certifications of my students?
Maybe it's only a matter of changing my tables structure.
Hi Angel,
Maybe you could create two tables. One will be the main tables with a link and other will be the table with student data. You can then place the student table on separate page and use "Defining filter values in the URL" option to pass student data as filter values to that page. When user click on the link in main table it will redirect it to the page with students table and apply filter defined in URL
Yes! That's the solution.
And one last question: I see always pagination in your tables. I don't want pagination in my main tables.
Is it possible to disable pagination?
In fact, I would like to remove all those options about ("Show n entries", "Print", "Excel", "CSV", "Copy", "Search") that is shown your tutorial video (minute 2) when you published table in Wordpress. I would like to show only the table.
Hi Angel,
It is possible to disable pagination by choosing all in "Default rows per page" option.
There is option to hide each element that you mentioned separately. You can find more info about it in our - Documentation