GEAR NBS Spreadsheet
When the creator of a form clicks on the “Complete and Save” button, the form is automatically published, generating an NBS spreadsheet in the Google Drive of the associated Gmail account
Locating your Spreadsheet
To properly view the spreadsheet, make sure you are accessing it on the same Gmail account that was logged in to when designing the form.
Rename Sheet
To rename your GEAR NBS spreadsheet, simply click on the Google Spreadsheet title and rename the sheet to fit your purposes.
Sheet Tabs
The GEAR NBS Spreadsheet has asset tabs at the bottom.
Barcode Scanner tab: [Your Form Name]
Once you open up the spreadsheet, click on the "Form Name" tab at the bottom of it to view your textfield titles. Once users start scanning items and submitting forms via mobile, information will be automatically entered into the Google Spreadsheet.
History Tab: [Your Form Name History]
With the "FORM NAME History" tab, you can see all scans histories. This tab stores the records of scanned items. On an initial scan, input a barcode number as "Insert". If the same code is rescanned, the system detects it as an existing item and updates the corresponding row. This provides much more detailed tracking than what's provided in Barcode Scanner tabs.