We have one little problem regarding data input from Google Spreadsheets. When we set URL from Google Spreadsheets to create our datatable, all the data gets "resorted" when they appear in our Wordpress website. We would like our data to be sorted exactly as they are sorted in our google sheet file, when imported.
Is there any way that our spreadsheet gets sorted exactly as they are in original Google Spreadsheet document, and not get resorted when imported?
I hope you have a solution for this one, thank you!
First of all any formatting in the file is not supported. As I can see you have some rows with the calculation in the rows 8and 17 and because of that you have the DIV in some of the cells.
Hi!
We have one little problem regarding data input from Google Spreadsheets. When we set URL from Google Spreadsheets to create our datatable, all the data gets "resorted" when they appear in our Wordpress website. We would like our data to be sorted exactly as they are sorted in our google sheet file, when imported.
Is there any way that our spreadsheet gets sorted exactly as they are in original Google Spreadsheet document, and not get resorted when imported?
I hope you have a solution for this one, thank you!
Best Regards,
Jernej Lukman
Hi Jernej Lukman,
Thank you for your purchase.
Can you please send me the link of that spreadsheet so I can take a look.
Best regards.
Kind Regards,
Miloš Jovanović
[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
Hi Bogdan!
Here is link to Google Spreadsheet: https://docs.google.com/spreadsheets/d/166rrGxKyo2Us2ad2Rxw9il0VSSZVShn0TDt5wq-3sxg/edit#gid=20125514
and this is link to the website, where it is placed: optimtrader.com/fnv/
Thanx!
Hi Jernej Lukman,
First of all any formatting in the file is not supported. As I can see you have some rows with the calculation in the rows 8and 17 and because of that you have the DIV in some of the cells.
You can check or documentation about formula columns and calculations for the rows.
When you import the table the data should look like from the file ( attachment).
Can you please tell me did you set some column to be sorted by the default?
Best regards.
Kind Regards,
Miloš Jovanović
[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
Hi Bogdan!
Thank you for your answer. I found the problem. I disabled Advanced column filters, Sorting and Main search block!
Thank you for your support!
HI insajder1987,
You are welcome.
If you have any more issues feel free to open a new ticket we will gladly help.
Best regards.
Kind Regards,
Miloš Jovanović
[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