Custom function in Javascript for Google Sheet
€30-60 EUR
Pagato alla consegna
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
Rif. progetto: #28876706
Info sul progetto
Assegnato a:
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 Altro
4 freelance hanno fatto un'offerta media di €52 per questo lavoro
I will do it when you need this done by tommrrow I will do it and update you so let me know Thanks