Topic: Google sheet script writing Tone: Formal/Professional Extensive research needed: yes Extra notes: Issue 1: Performance of Row Updates We are using Google Sheet to track the status of different project tasks. These tasks exist as sheet rows and are assigned to different individuals on the project. In order to track changes to the task status we have protected the sheet from direct changes and implemented a html form that is selected using the menu. When it runs, the changes are validated, and then recorded on another "History" sheet. urlFetchApp is then invoked to run a Google script webapp to update the Original sheet. This was done to be allows users to update the protected sheet. We are noticing that urlFetchApp is taking over 4 seconds to complete. We are wondering if there are alternative designs to help improve the performance. Issue 2: Row Selection We need a way to select rows on Google Sheet that need to be update. I found that using radio buttons is not feasible because images are not tied to row cell (Inserting Image) or we cannot have a script that can run when the image is clicked (via IMAGE Function). Since multiple people can update the sheet at the same time, we have decided to used a dropdown cell data validation which allows the user to select their name in Column 1. A users will updates Column 1 all the desired rows with their names and then selects the Menu "Update" option. A query function will then run to identify rows belonging to session user and make the updates accordingly. We are wondering if there is a better way than selecting their names for rows and clicking Menu "Update".
?Bidding for first time? Click here to learn how StartAJob platform works.
?Want to do the job or have questions for the customer? Write then in the " Write a note or message to the customer"
?You already have the estimated cost and time to complete the work yuo are in the fields "Execution time" and "Payment requested" or leave them empty and can be changed later.