Topic: Datatables importing data from Google Sheets
I want to import data from google spreadsheet using snippet (https://mdbootstrap.com/snippets/jquery/ascensus/453950) to sorting datatable (https://mdbootstrap.com/docs/jquery/tables/sort/).
Data load correctly after connection, but first row of the table displays "No data available in table" and sorting/searching options does not work as table did not see any data after connection.
sonictrip answered 3 years ago
Would you kindly update your snippet? The old way of importing data from Google Sheets to sorting datatable doesn’t work anymore after Google updated the Sheets API to new version. I want as previous the columns to continue to be considered as variables, because I would like to use them in the next step - if at all possible.
I can't figure it out by referring to the updated version of the snippet: https://mdbootstrap.com/snippets/jquery/ascensus/453950
Thank you in advance for your help.
Grzegorz Bujański staff commented 3 years ago
Here you will find tutorial: https://www.youtube.com/watch?time_continue=577&v=5BvarQdBtFk&feature=emb_title. Everything is described in detail in it. If you have done everything as in the tutorial and it still doesn't work for you, please send us a snippet. I'll check what's going on
FREE CONSULTATION
Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.
Answered
- User: Free
- Premium support: No
- Technology: MDB jQuery
- MDB Version: 4.13.0
- Device: PC
- Browser: Chrome
- OS: Windows 10 Pro
- Provided sample code: No
- Provided link: Yes
Grzegorz Bujański staff commented 5 years ago
Please create snippet here: https://mdbootstrap.com I will look at this.
sonictrip commented 5 years ago
Thank you in advance. Snippet here: https://mdbootstrap.com/snippets/jquery/sonictrip/1774529
Grzegorz Bujański staff commented 5 years ago
Try this: https://mdbootstrap.com/snippets/jquery/grzegorz-bujanski/1778379
sonictrip commented 5 years ago
Perfectly, everything works as intended. Thank you so much for your help, I'm closing post.