Custom function in Javascript for Google Sheet

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

Google sheet “EdoWords” is shared between User1 (owner rights) and User2 (editor rights).

Please refer to the enclosed Google Sheet “EdoWords”.

Use case to be developed as following.

User1:

- opens “EdoWords”

- selects “Word” sheet

- selects one row (row number >1) (using mouse or cursor). This row is referred later ROWUSER1

User2:

- opens (concurrently) “EdoWords” (no matters if on the same device)

- selects “Test” sheet

- inserts a word in cell C2

Function “checkWord” to develop in Javascript inside “EdoWords”:

- triggered just with “onEdit” event connected to “Test” cell C2

- if word (trimmed) inserted by User2 in “Test” C2 is equal with word (trimmed) selected by User2 in “Word” (column A of selected row ROWUSER1):

1) cell in “Word” column “TRIAL” of selected row ROWUSER1 is increased +1

2) cell C3 of “Test” is set to “OK”

3) cell C2 of “Test” is set active for User2

ROWUSERS1 is set active for User1

JavaScript Google Chrome jQuery / Prototype HTML Google Sheets

Project ID: #28876706

About the project

4 proposals Remote project Active 3 years ago

Awarded to:

hardikpurohit26

Easy task to do. A simple script to write. I will start working on it, as it won't take more than 2 hrs. I will take payment when you are completely statisfied. [I will add url to the sample sheet HERE, when i complet More

€60 EUR in 1 day
(3 Reviews)
2.9

4 freelancers are bidding on average €52 for this job

avinaykumarweb

I will do it when you need this done by tommrrow I will do it and update you so let me know Thanks

€55 EUR in 7 days
(63 Reviews)
6.2
dibinn1

Hello. I am a front-end web developer with 10+ years of JavaScript/jQuery, HTML/HTML5, CSS. I read your post and I thought I was the right person for your project because I am expert in JavaScript. Let me know more det More

€46 EUR in 7 days
(0 Reviews)
0.0
doggokt

Hey there! I can make you such a function with no problems in a few days. I'm a professional JavaScript developer with lots of experience with various APIs and environments. I'd definitely be happy to work with you and More

€45 EUR in 5 days
(0 Reviews)
0.0