Datatables importing data from Google Sheets


Topic: Datatables importing data from Google Sheets

sonictrip free asked 2 years ago

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.

enter image description here


Grzegorz Bujański staff commented 2 years ago

Please create snippet here: https://mdbootstrap.com I will look at this.


sonictrip free commented 2 years ago

Thank you in advance. Snippet here: https://mdbootstrap.com/snippets/jquery/sonictrip/1774529


Grzegorz Bujański staff commented 2 years ago

Try this: https://mdbootstrap.com/snippets/jquery/grzegorz-bujanski/1778379


sonictrip free commented 2 years ago

Perfectly, everything works as intended. Thank you so much for your help, I'm closing post.


sonictrip free answered 1 month 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 1 month 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


Please insert min. 20 characters.

FREE CONSULTATION

Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.

Status

Answered

Specification of the issue
  • 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