Warlow
07-09-2014, 08:15 PM
Hey Guys,
I work for a call centre environment and I'm trying to create a tool for support staff to quickly log a "job" to track productivity and capacity.
It stores some basic info, Who supported, how long, context to the support.
The purpose for my tool is simply to capture this information and deposit it into a central spreadsheet for analytics/reporting later.
I have the form working and the data appears in A1 (initially, then a2 etc) through to F1 (f2, f3 etc)
This is an example of my headings and the first line of data populated by
===========================
Consultant
Help with?
Work Required
What caused the pull?
Time Spent
Details
george
stuff
handoff
Lack of product knowledge
2
handed off to steven
===========================
My problem is that multiple users will be running/using the form at any given time and due to my extremely limited knowledge of coding, I don't know how to avoid each of these users saving over eachother's submissions without hitting save before submit, which you can't do because the form is open.
What I came up with was a mechanism to send the data from the "JPAPP" spreadsheet through to a new workbook I label as "JPAPPDATA.xlsx". The end result being that each support staffer will run the app and every time they submit it will pile up in the first available slot in the JPAPPDATA.xlsx.
I have created a button to "export" my data and I've found a few examples of code I could use, but as this is my first project and I'm learning this code on the fly, I'm not skilled enough to modify it to suit my needs.
I had posted a couple of links to reference some examples of code I have scavenged, but until I have 5 posts I can't include them :(
I'm sorry, if I knew enough to write code to use as an example I would, but I'm still early in my learnings!
I'm trying to get this finished by friday (business deadline) and I'm swimming a bit. Any assistance would be greatly appreciated!
I work for a call centre environment and I'm trying to create a tool for support staff to quickly log a "job" to track productivity and capacity.
It stores some basic info, Who supported, how long, context to the support.
The purpose for my tool is simply to capture this information and deposit it into a central spreadsheet for analytics/reporting later.
I have the form working and the data appears in A1 (initially, then a2 etc) through to F1 (f2, f3 etc)
This is an example of my headings and the first line of data populated by
===========================
Consultant
Help with?
Work Required
What caused the pull?
Time Spent
Details
george
stuff
handoff
Lack of product knowledge
2
handed off to steven
===========================
My problem is that multiple users will be running/using the form at any given time and due to my extremely limited knowledge of coding, I don't know how to avoid each of these users saving over eachother's submissions without hitting save before submit, which you can't do because the form is open.
What I came up with was a mechanism to send the data from the "JPAPP" spreadsheet through to a new workbook I label as "JPAPPDATA.xlsx". The end result being that each support staffer will run the app and every time they submit it will pile up in the first available slot in the JPAPPDATA.xlsx.
I have created a button to "export" my data and I've found a few examples of code I could use, but as this is my first project and I'm learning this code on the fly, I'm not skilled enough to modify it to suit my needs.
I had posted a couple of links to reference some examples of code I have scavenged, but until I have 5 posts I can't include them :(
I'm sorry, if I knew enough to write code to use as an example I would, but I'm still early in my learnings!
I'm trying to get this finished by friday (business deadline) and I'm swimming a bit. Any assistance would be greatly appreciated!