User Guide for G Suite users

3. Setting Up Form

Click “Create New Spreadsheet from Dynamic Form” As the G Suite Super Admin, you will be creating a form that will prompt users to input information based on the text fields you create when they are scanning items on their mobile device.
 

This step is important to set up prior to operations. The form you create will prompt users to input information based on the text fields you create when they are scanning items on their mobile device. The inputted information will then be automatically transferred onto your “Netkiller Barcode Scanner_2.0” Google Sheet that is created once you complete and submit this New spreadsheet.

 

 

 

 

 

 

 




On the following screen, create a form. The form created will appear to users when opening up the NBS each time to prompt input of information required on this form.
 

3.1 Field Types


Click the arrows on the barcode field for the drop down menu options. We have many field types to select from when designing your custom form. Utilize our various field types to create a form fit for your needs. Please note that form Field Title should not have symbols when you rename it. Otherwise, it will cause error in submit. 
 

  • Barcode: This field will automatically input the barcode number when you scan a barcode from your mobile device. This field is important to add to your form if you want to transfer and store barcode numbers to your Google Spreadsheet.
     

  • Timestamp: This field will record the time of scan. It can be used as a last updated record, or a timestamp for data records.
     

  • Date: This field to choose date from calendar.
     

  • Short Answer: Text can be entered onto this field in correlation to what the text field has been renamed to and requires.
     

  • Paragraph: This field reserves space for longer comments and notes to be made.

 

  • Dropdown: Title a dropdown list for anything you may need to use it for. Such as “Location” and by selecting your dropdown list arrows, you can list options such as “Warehouse”, “Main Office”, “Parking Lot”, “Conference Room”. A dropdown list is great for selecting preset options.

  • Checkboxes: Multiple Selection Checkboxes. A box will appear next to the name to select or unselect.
     

  • Number Count: User can click plus or minus to adjust number for quantity. Useful to use for volume for same barcode.
     

  • Radio Button: Radio buttons can designed to select options on the form. Multiple options can be created with buttons appearing next to each option. Only one selection can be made.
     

  • GPS Coordinates: A field to record a scanned location. It will create two fields - Longitude and Longitude, and Google Maps link.
     

  • Secondary Barcode: Users can scan a second barcode and the second barcode will be registered in the same row on Google Sheet.
     

  • Hidden: A hidden field will not be displayed on the form but show on Google Sheet. 
     

  • Image: A field to upload or take a picture from mobile. Upon submit, the file is uploaded to Google Drive and the link is recorded in Google Sheets. Please note that if the file is large or being uploaded to drive, it may take some time until the form is fully submitted.
     

  • Stock: A field to control stock In/Out quantity and activity. It will create three fields - Current Stock, Choose In Out, and Quantity. Current Stock shows the total stock quantity. Choose In Out is drop-down with In and Out option. Choose In/Out and enter quantity and change will apply into Current Stock after submit. For example, if Current Stock shows as 10 and user select 'In' under drop-down, enter 3 quantity and submit, then Current Stock will show as 13 when the same barcode item is re-captured.
     

  • Current User: Current user's email is recorded upon form submit. It is useful if multiple G Suite users are using the app. 

​​

3.2 How to Add Fields

As a default, Barcode and Timestamp fields are automatically added. You can add more fields by selecting drop-down and click [+ Add Field] button.   Continue to add more fields until you have created a form fit for your purposes.

 

 

 

 

 

 


 

3.3 Edit Field Options


For more field edit options, click the [+] on a field on your form. This will expand your options on the specific field you have selected.

 

  1. Rename: Any field can be renamed. In your field type, locate where it says Field Title: and rename the title. Text and numbers only. Symbols are not allowed. Titles renamed with symbols may cause an error with data transfer from your scan to your Google sheet. (i.e. Last Updated can be renamed to “Timestamp”
     

  2. Required Field: If Yes is selected for the Required, the user scanning via mobile must fill out that fieldtype in order to submit the form and any changes.
     

  3. Disable: “No” on disabled will allow regular access to the field type. “Yes” on disabled will not allow any user input on the form.
     

  4. Delete: To delete a field, click the red delete button to remove the field type.

 

3.4 Preview Form

 

Once you have designed your form, it is a good idea to preview what the form would appear as when you have scanned a barcode via mobile. Select [Preview Form] for a pop-up view of your form. Preview mode also allows viewing drop-down menus and more.

 


3.5 Complete and Save (Publish Form)


Click [Complete and Save] to officially publish the form you have created. You, or your users will now be required to fill out the form created each time they use the NBS. You can always edit the form after publishing. Please visit section Editing the Form for more on how to edit a published form.

After your form is Completed and published, your screen will appear as seen here. Refer to this screen in Mobile Scanning step for QR code when launching your mobile app scanner.


 

3.6 Google Sheet Generation

 

Once you have clicked [Complete and Save] for your form, you will receive a notification that a Google Sheet has been created and to locate it in your Google Drive. A Google Spreadsheet correlating to your form text fields will be automatically generated and can easily be found by going to your Google Drive. Make sure you are on the same Gmail account were logged onto when the form was created. Please visit section 5. Netkiller Barcode Scanner 2.0 Spreadsheet for more on where to locate your Google Spreadsheet, how to rename the spreadsheet, and data stored in the sheet tabs.