Cancelled

Your job is rejected! Reason:

Google sheet script developer

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".

Additional info

Job: #9721

2348 day(s) 21h 51m

Budget:

$180

Job type:

One time job

Working Hours:

00:00 - 08:00

Required skills
Posted by

Mobile:

N/A

Get the job done

To apply for this job you must first login/signup.

click here to learn How It Works

Invite
FAQ

click here to learn how StartAJob platform works?

Write then in the "Write a note or message to the customer"

You already have the estimated cost and time to complete the work you are in the fields "Execution time" and "Payment requested" or leave them empty and can be changed later.

If you can get the job done, place your offer in the form bellow or if you have additional questions, you can write them in your remarks field and leave the “desired salary” and “completed within” fields empty. They could be set later.