Summarizing user input in the form

What you'll be learning:

  • how to count and summarize user input in a form using hidden labels as helper variables, and the COUNT and SUM query operators

  • how to add a datepicker and a signature control to a form

  • how to add a barcode scanner control to a form

In this section, you'll finish up the Vehicle Inspection form, adding the finishing touches to your creation.

Problem: The user of the form has to go inside the popup panels in the form to check the result of the inspection. This is inconvenient.

Solution: put an automatically updating running total of all the positive and negative inspection results outside the popup panels, so the driver can see it as soon as he or she opens the form.

Looks familiar? This part is labeled 3 in the overview of the final form

Figure 90. Looks familiar? This part is labeled 3 in the overview of the final form