Task 2: Create a counter in Table.onCreate To count the number of customers whose names contain the string Mini, first declare a global counter and set its value to zero. The Table.onCreate method is the most appropriate place to perform this task because Table.onCreate executes before retrieving any rows. In the next task, you conditionally increment this counter in the Row.onCreate( ) method. 1 In Layout, select the table by placing the cursor near the bottom left corner of the table. The table icon appears, as shown in Figure 22-5. Figure 22-5 List icon in the layout editor 2 Choose the Script tab. The script editor appears, as shown in Figure 22-6. Figure 22-6 Script window 3 Select onCreate from the list of available scripts. 4 Type the following line of code in the script editor for the onCreate method: countOfMinis = 0; 5 To run the report and verify that the code did not create any errors, choose Preview. 6 Scroll to the bottom of the report, where JavaScript error messages appear. If there are no errors, the report appears as shown in Figure 22-7. If you see an error message, you may have typed the statement incorrectly. If so, go back to the script window, select the method you just modified, correct the error, and choose Preview again. Figure 22-7 Report preview
To count the number of customers whose names contain the string Mini, first declare a global counter and set its value to zero. The Table.onCreate method is the most appropriate place to perform this task because Table.onCreate executes before retrieving any rows. In the next task, you conditionally increment this counter in the Row.onCreate( ) method.