Logging tool (advice - how would you do it?)

• wrightyrx7

  Old Hand

  Points: 312

  More actions

  March 18, 2015 at 6:50 am

  #302085

  Hi all,

  The reason for this thread is to see how you guys with coding experience would create this tool, which programming language to use is the main goal out of this thread. Then i will go away and attempt to learn and code this tool.

  I have been given a project in work, the project is to make a Telephone Call logging tool. I am just an admin with little knowledge of programming, but picked up VBA in excel pretty well so am looking forward to learning something new.

  This will be for when employees call our department, below is the basic feature I want to incorporate.

  --Multi User interface

  --There will be a field for the employee number, when this is entered it will pull the basic details from an SQL table (i.e. Forename, Surname).

  --When the employee number is entered it will pull through any historic calls

  --We will then add a record in relation to the call

  --Mark as Dealt with or outstanding

  --Assign call to another user with access to the tool

  --Set priority

  --Be able to generate reports of calls

  All the basic data for this tool is stored in a SQL table (read only table) the details from the table will be for Display purposes ONLY so the person logging the call knows they have typed the correct 'Employee ID'.

  All the details of the call should be saved to another table if this is the only way to store the data from the call.

  I look forward to hearing your suggestions on this thread.

  Regards

  Chris