Write some Software

Job/Employee Feedback using Google Sheets/Google Apps Script Summary I have developed a spreadsheet using Google Sheets which sorts work orders and tracks feedback from customers. The spreadsheet is designed to track both work order specific feedback and employee specific feedback. I have created the basic structure but need someone with experience in Google Apps Scripting, HTML, jQuery and User Interfaces to help add a user interface to my Google Sheet so my users (aka, my employees) can easily add feedback for jobs and employees. Objective The primary objective is to allow my users to quickly and easily add feedback through a user interface using drop down menus, checkboxes and save buttons. The resulting data would be saved in rows to specific sheets. History A script was developed for the job feedback portion of my project. After some testing it was determined that we needed some additional user interface elements to help sort feedback values and make it easier to add them. My original developer was unavailable due to other commitments. The existing code will be at your disposal but I\'ve changed some aspects of the layout of the spreadsheet which has broken it. My initial developer said that my new request would likely require a complete reworking of the code anyway. Job Description I wish to have two separate scripts developed which can be launched separately. I have a write up detailing how each one should work. Job Feedback [login to view URL] Employee Feedback [login to view URL] Since they\'re both very similar in structure I would suggest reading the Job Feedback write-up first. The Employee Feedback sheet references back to the Job Feedback quite a bit. Here are the spreadsheets. Google Spreadsheet (Developmental Version) https://docs.google.com/spreadsheets/d/1SXCPd_HdPn4G2UtYS3NtZvTFZeoLcS-OgOTwyOX6NxM/edit#gid=885362727 NOTE: I have it available as a view only. I believe you can copy it over but if not please let me know and I can share it with you. Please note that the existing script on this version is broken due to changes in the sheet names and overall structure of the spreadsheet. Google Spreadsheet (Current Functioning Version) [login to view URL] NOTE: This is a copy of the current sheet with the working script. Please note that I currently only have the job feedback script. The employee feedback script was never developed. Time frame: Mid July