Event Tickets Management System for Smartphone and Google Sheets

The Netkiller Barcode Scanner has several versatile uses. The most widely use-purposes for the NBS are: keeping attendance records, membership rewards program, asset and inventory management, and event tickets management.

The Netkiller Barcode Scanner app can be used as an efficient ticket scanning system for any size event. Whether it is for nonprofit events, theater performances, art shows, music venues, etc. the barcode scanner app will conveniently scan the event ticket and each entry ticket is processed and recorded onto the event manager’s Google Spreadsheet stored in their Google Drive.  

Event Tickets Management System Use Case

The events coordinator is hosting an event on Friday night. Those that signed up for Friday’s session and pre-paid online are instructed to print their e-ticket on Friday when they arrive, or to present their e-ticket via mobile for scanning. A week prior to the event, the event coordinator sets up the Netkiller Barcode Scanner app in advance to be prepared for the upcoming event session.

To setup the Netkiller Barcode Scanning App:
  1. The events coordinator goes to the following link: http://bc-scanner.appspot.com login with his gmail account and permit access permissions to begin

  1. The coordinator can begin to create a form by clicking “Create New Spreadsheet from Dynamic Form”.

  1. The events coordinator creates a form consisting of the following fields:
    • Barcode Ticket Scan Number (automatically filled in by scanner)
    • Timestamp (automatically filled in by scanner)
    • Ticket type:
      1. General Admission
      2. Child
      3. Senior
    • Re-entry checkbox
Preview of the form the events coordinator created

  1. Attendees present their ticket barcode at the time of the event at check-in and have their ticket barcodes scan upon entry.
The check-in ticketer scans the barcode with a mobile device and submits the form

  1. Each initial check-in scan is recorded as an “Insert” action in the History tab of the Google Spreadsheet. Each ticket that is rescanned and checked as a Re-entry is recorded as an “Update” action.

The Barcode Scanner tab of the Google Spreadsheet displays each scanned barcode number with the most current scan information for easy viewing.
Barcode numbers that appear as “Selected” under the Re-entry column show attendees that have re-entered the event after their first check-in scan.

The Netkiller Barcode Scanner app is great for managing event tickets. All ticket scan submissions are instantly recorded into your Google Spreadsheet for accurate admission records. Utilize the app to your benefit for your next event!

Cloud Integration & Aggregator Google for Work & Google for Education Partner

Netkiller Barcode Scanner Update, New ‘History Log’ function and limited ‘Scope’ of permissions

The Netkiller Barcode Scanner has been updated with two major improvements! Now users can access a History Log feature in the Netkiller Barcode Scanner Google Spreadsheet and operate at ease with minimal access permission requirements from the app.

1. Scan History tab feature in Google Sheets

Now when a user scans a barcode via mobile device, each scan is individually recorded in the Google Sheets “History” tab, while the Google Sheet “Barcode Scanner” tab displays the most current/latest information of each item.

The History tab logs all initial and repeating scans of a barcode individually on the spreadsheet and displays submitted information from mobile devices. The History tab will show initial scan of items and rescanning of the items with updated information.

Android iPhone

Press [Submit Changes] on mobile screen after inputting information. The information will instantly be recorded onto the Netkiller Barcode Scanner Google Sheets.

Now in your Google Sheets located in your Google Drive, you will be able to find the “History” tab that displays all initial scans and repeated scans with updated information.

A record of all scanned items is stored in the History tab. Under the “Action” column, new barcode numbers to the system are inputted as “Insert” on the initial scan. Once a barcode is rescanned, the system will detect it as an existing item and it will be inputted as an “Update” action.

Just as before, the “Barcode Scanner” tab displays an item’s current/latest status.

2. Google Account ‘Scope’ adjusted to ensure User Privacy

To address users’ concern regarding their Google account privacy and security, we have updated Netkiller’s Barcode Scanner initial access permission with very limited scope accessibility.

When launching the Netkiller Barcode Scanner, it will now only ask for access permission to your email address, basic access your Google Sheet and Google Drive. These functions are required to permit information transfer and properly record mobile submissions onto your Google Sheet. Netkiller Barcode Scanner never store your data into the server. Your data is safely saved in your Google Sheet.

Screen Shot 2016-08-30 at 11.20.34 AM.png

Simply logon to the Netkiller Barcode Scanner app, capture a barcode and check your individual scans under the “History” tab in your Google Spreadsheet. This update will allow users to manage assets and have a reliable record conveniently stored in their Google Drive!

We are proud to release this new update and are further working to enhance our apps for Netkiller users!

Cloud Integration & Aggregator Google for Work & Google for Education Partner