Create a QR Code That Links Back to Field Management

QR Codes can be a handy tool out on the field. You create a QR Code so your users can easily pull up the piece of equipment or the training history on an employee by scanning with a QR Reader.

Below are the steps to make this available.

Create a URL

  • For Equipment: [portalurl]/Equipment/#/EMEMKeyID/[Key ID from EMEM table for the equipment]

    • Portal URL: this is your current portal URL (Example: https://myFieldManagementPortal.com)

    • Key ID: You can get the Key ID from table.columname EMEM.KeyID or use the following select statement:

      • Use Viewpoint
      • Select KeyID, EMCo, Equipment, Description
      • From dbo.bEMEM
      • Order By KeyID
      Note: To get to this table you must be logged into your SQL Server management Studio as the system admin and connected to the server where your Vista dn KDS-HRIM database live.
    • Example: https://myFieldManagementPortal.com/Equipment/#/EMEMKeyID/100
      • Portal URL = https://myFieldManagementPortal.com
      • Key ID = 100
  • For Training: [portalurl]/employee/training/#Manager/Y/HRCo/[the hr company of the employee]/Employee/[the employee number]
    • Example: https://myFieldManagementPortal.com/employee/training/#Manager/Y/HRCo/1/Employee/100
      • URL = https://myFieldManagementPortal.com
      • HR Company = 1
      • Employee = 100

Generate your own QR Code

  • Use the URL's created above and enter into a QR Generator to create your own QR Codes for each piece of equipment or employee.

How does it work?

  • After you have created your QR Code, the user can easily get to that page by using a QR scanner.
    • The user will have to be logged in to get to the page.
    • If the user does not have permission (Ex: they are not assigned to the module or don't have permission to view that employee's training), they will not be able to open the page.