Table Counting

Thus far we've used an if/print structure inside a loop to select certain rows to print or not. In this short section, we'll use a variable with a little code to count how many times an if-test is true. Below is a loop as we have seen before that detects all the names that start with "A". After printing the rows, the code prints a summary of how many names started with "A".

Code To Count

Three additions to the standard loop/if/print structure we've used up to now:

Inside the if-statement, count = count + 1; increases whatever number is stored in count by 1 when the if-test is true. This is a weird use of the equal sign = vs. how it works it mathematics. First it evaluates the right hand side. Then it assigns that value back into the count variable, so in effect it increases the number stored in count by 1. The increase-by-1 operation is so common in computer code, many languages including Javascript support the shortcut count++; to mean increase by 1.


Experiment solutions:

If logic inside the loop:

  // 1
  // It still produces the count: NN output, just without all the row printing first.

  // 2
  // count names starting with "X" (then change to "Y")
  if (row.getField("name").startsWith("X")) {
    count = count + 1;

  // 3
  // count girl names beginning with "A" (then change "girl" to "boy")
  if (row.getField("name").startsWith("A") &&
      row.getField("gender") == "girl") {
    count = count + 1;

> exercises