Answers

• allan Posts: 61,660Questions: 1Answers: 10,094 Site admin

  August 2022

  How are you currently importing the sheet into DataTables?

  Allan
• Paul624 Posts: 6Questions: 2Answers: 0

  August 2022

  Javascript, I believe. I can share some of the code if need more information?
• kthorngren Posts: 20,274Questions: 26Answers: 4,765

  August 2022

  Please share the code so we can see how you are getting the data and importing into Datatables.

  Kevin
• Paul624 Posts: 6Questions: 2Answers: 0

  August 2022 edited August 2022

    <script>
          var key = "https://docs.google.com/spreadsheets/d/e/2PACX-1vRaiTmUKjtQ7MxiGibN2GAZ8m9NHF3IA2U-yE0PhBpCOXHewhs57PrjZO7GQzZvrEGGBW7HFEE43yX0/pub?output=csv";
          var columns = [{"data": "Name"}, {"data": "StartingPredicted"}, {"data": "Team"}, {"data": "Position"}, {"data": "Ownership"}, {"data": "Price"}, {"data": "Fixture"}, {"data": "Start"}];
          $(document).ready(function() {
              function init() {
                  Papa.parse(key, {
                      download: true,
                      header: true,
                      complete: setupTable
                  })
              }
              init();
              var ownership_vals = [20, 15, 10, 5, 2, 1];
              function setupTable(result) {
                  var data = result.data;
                  $('#predicted_starting').dataTable( {
                      "data": data,
                      "columns": columns,
                      "order": [[1, "desc"], [5, "asc"]],
                      "autoWidth": false,
                      initComplete: function () 
  

  Edited by Kevin: Syntax highlighting. Details on how to highlight code using markdown can be found in this guide![]
• kthorngren Posts: 20,274Questions: 26Answers: 4,765

  August 2022 Answer ✓

  You are using Papa Parse to get the Google sheets not Datatables. You are using Datatables to display the resulting data. See if this tutorial about using Papa Parse with Google sheets helps with setting up links for the different sheets.

  Kevin
• Paul624 Posts: 6Questions: 2Answers: 0

  August 2022 edited August 2022

  That did answer my question - for those wondering, simply publish to web but select that given sheet only and use the given URL.

  Thank you for the responses.