Fetching data from Google Sheets or a URL - Official support forum | RGraph.net

Fetching data from Google Sheets or a URL


Posted by lieuwe Montsma at 12:49 on Saturday 8th January 2022 [link]
Am absolutely happy with the RGraph charts.
have 2 questions:
a. var scores = sheet.get('H2:K2'); Can I add a selection criteria as for example:
var scores = sheet.get('H2:K2') where score = 3;
b. can I use an URL variable as the selection criteria? Or use the URL variable as input for a graph?

thax in advance

Leo


Posted by Richard at 15:54 on Saturday 8th January 2022 [link]
a. You can't add selection criteria but you can easily do that with a for() loop after you fetch the data:

var row = sheet.get('H2:K2');

// Change values that aren't 3 to null, and populate a new
// array (row2) with those values.
for (var i=0,row2=[]; i<row.length; ++i) {
    if (row[i] !== 3) {
        row[i] = null;
        row2.push(row[i]);
    }
}

b. I don't know your setup so there are two possibilities I can think of. You could get the variable from the URL using server-side scripting (for example PHP). So that would change the above code to:

for (var i=0,row2=[]; i<row.length; ++i) {
    if (row[i] !== <?php echo intval($_GET['myVariable']) ?>) {
        row[i] = null;
        row2.push(row[i]);
    }
}

An example URL would be:

/foo.php?myVariable=3



Another way would be to use JavaScript:

var params = new URLSearchParams(location.search);
var myValue = params.get('myVariable');
    myValue = Number(myValue);

for (var i=0,row2=[]; i<row.length; ++i) {
    if (row[i] !== myValue) {
        row[i] = null;
        row2.push(row[i]);
    }
}

[Replies are now closed]