Käynnissä

Google Sheets Script - Lock Row Bases on cell value

I require a google script to lock a row and add timestamp for when a check box is ticked to true. ( there will be a check box in each row) The locking of the row will mean editors can no longer edit that row and only the owner of the sheet can.

For example if yes is clicked in A1 then row 1 is now locked to all editors and only editable by an owner.

If yes is ticket in A100 then row 100 is now locked to all editors.... and only editable by an owner.

****Please Respond with the following****

Have you created something this is before? If yes, how?

How long will the task take you?

Only candidates that respond with the above will be considered

Taidot: Google Sheets, Excel

Näytä lisää: can you lock individual cells in google sheets, how do i lock a cell in a formula in google sheets?, lock filters in google sheets, how to lock a cell value in google sheets formula, auto-lock-cells-after-data-entry google sheets, how to lock cells in google sheets, how to lock borders in google sheets, conditional locking of cells in google sheets, excel add row based cell value, \ google sheets script\ , \ google sheets\ script, google sheets send email based on cell value, google sheets script, google sheets script editor, google sheets script functions, google sheets script permissions, google sheets script examples, google sheets script download as csv, import csv into google sheets script, google sheets multiple hyperlinks in one cell

Tietoa työnantajasta:
( 4 arvostelua ) Melbourne, Australia

Projektin tunnus: #25692261

Myönnetty käyttäjälle:

rakeshppatil11

Hello, Yes, I did almost same task with event trigger, first we have to add event listener and lock the row. I read job description and this letter is to express my interest to do your task. With hands-on experienc Lisää

$172 AUD 1 päivässä
(1 arvostelu)
1.8

19 freelanceria on tarjonnut keskimäärin 97$ tähän työhön

AnowarRatul

$59Only -----Hello Sir, I have seen to your project details very carefully. I am ready to work on this project. -------Google Sheet, Excel VBA Macro Coding, Formula Generation and Automation process expert with 5* ratt Lisää

$59 AUD 1 päivässä
(107 arvostelua)
5.3
NaliRaz

Hi, Yes, I've done something like this before. Need to add an event listener and lock the row after that. Will be done withing 24 hours. Please, feel free to contact me over chat. Best regards, Naly

$99 AUD 1 päivässä
(4 arvostelua)
3.9
sskannan52

Hi, Greetings! I have worked on the google scripts earlier. Based on the Understanding from your requirements, I have created the sample worksheet using event trigger function. [login to view URL] Lisää

$80 AUD 1 päivässä
(2 arvostelua)
0.8
rajendra111111

Greetings, Hope you are doing well. I would like you to consider me as an eligible candidate for this job as I have experience in working with Excel. I assure you that you will not be disappointed. Thank you!

$140 AUD 7 päivässä
(0 arvostelua)
0.0
Vickysingh57

My economy condition is poor But I will do this work better then everyone I will not make you sad Please sir Thank you sir

$156 AUD 3 päivässä
(0 arvostelua)
0.0
venkykawale

I can deliver for project in less time and in less money i my expert in excel and can show a dome about you ask for

$45 AUD 3 päivässä
(0 arvostelua)
0.0
$156 AUD 2 päivässä
(0 arvostelua)
0.0
njayamaha7

I have read your job description and I understand how to execute this project since I have done similar jobs before. I will perform your job 100% perfectly without any single mistake under the giver conditions. If I am Lisää

$30 AUD 3 päivässä
(0 arvostelua)
0.0
YEDP

Dear Recruiter, I am working as an admin clerk since 2006, So my capacity for this task is reliable. Above all, I am available 24/7 to complete this project ASAP. Please approve my quote. Sincerely, Prasanth

$140 AUD 7 päivässä
(0 arvostelua)
0.0
mbmathapati123

I am in need of money.

$30 AUD 1 päivässä
(0 arvostelua)
0.0
Rahul2232001

Hi, I have gone through your requirements and I can do this task. The skills and resources needed for this project are in my genes. I can assure you for a complete professional work in given time line. Please share com Lisää

$50 AUD 1 päivässä
(0 arvostelua)
0.0
matnas242

I have worked like this task and my experience more than 5 years is guarantee to finish it on a time.

$35 AUD 1 päivässä
(0 arvostelua)
0.0
$111 AUD 3 päivässä
(0 arvostelua)
0.0
choopzmedia

Can help create custom scripting for your Google Sheets. Should we assume that it's some form of "Confirm / Lock" feature whereby only the owner can "Uncheck / unlock" the rows again if necessary? I am a senior web de Lisää

$50 AUD 1 päivässä
(1 arvostelu)
0.0
kaushalshingala7

I am an expert in Excel and data entry with more than 3 years of experience and I can handle your project easily

$182 AUD 7 päivässä
(0 arvostelua)
0.0
kochatha

I have 5 years experience in excel. I'm new here hence quoting low. I haven't done anything like this before. But I can do it in one day. Thanks, Ajay

$30 AUD 1 päivässä
(0 arvostelua)
0.0
moinmk548

Yes I have done something this before.I will take 2 days to complete. I have read the project description.I am very much interested to do this job. I have 5 years of experience in Data Entry, Data collection , Da Lisää

$30 AUD 2 päivässä
(0 arvostelua)
1.1
NamishaVoice

Hi, I have read your requirement and this can be accomplished using a Google Apps Script. Though I haven't done this specific task before so I don't have any example to show you, I will only bill for payment on succes Lisää

$250 AUD 5 päivässä
(0 arvostelua)
0.0