Displaying Data from Different Sheets in Google Sheets

Paul624

I have a datatable displaying data from a Google Sheet, which works fine. That's from the default sheet (Sheet1), though.

I want to display data from a different sheet (tab) but can't find how to do that (Goal/Assist or Predicted).

Have attached image showing sheets I'm referring to if it wasn't clear.

FYI I have a very basic understanding of coding so please talk to me as such

allan

How are you currently importing the sheet into DataTables?

Allan

Paul624

Javascript, I believe. I can share some of the code if need more information?

kthorngren

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

Kevin

Paul624

  <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

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

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.