Find Jobs
Hire Freelancers

Resolve script not running properly for multiple items selected quickly

$10 USD

Inaendelea
Imechapishwa over 5 years ago

$10 USD

Kulipwa wakati wa kufikishwa
I need to be able to select all for multiple items quickly and have this script still be able to run without error. We can reserve the top row if needed and create a button if needed. The script is below and here is a video also which illustrates the issue. [login to view URL] This task must be done within Google Sheets and cannot be stand-alone Excel function onEdit(e) { var id_cell_val = 0; var source_row = [login to view URL](); var source_col = [login to view URL](); var unique_col = 1; var checkbox_col = '8' var target_sheet = [login to view URL]().getSheetByName("[login to view URL]"); var source_sheet = [login to view URL]().getSheetByName("Build Email List"); var col_len = 50; var found = 0; var last_row_target = [login to view URL](); if(checkbox_col == source_col && [login to view URL]().getActiveSheet().getName() == 'Build Email List'){ var row_id = [login to view URL](source_row, unique_col).getValue(); var chk_val = [login to view URL](source_row, source_col).getValue(); var source_range = [login to view URL](source_row, unique_col, 1, col_len); var target_range = [login to view URL](last_row_target+1, unique_col, 1, col_len); if(last_row_target > 0){ for(var i = 1; i <= last_row_target; i++){ id_cell_val = [login to view URL](i,unique_col).getValue(); if(row_id == id_cell_val){ if(chk_val == 0){ [login to view URL](i); found--; } found++; } } if(chk_val == 10 && !found){ [login to view URL](target_range); } } }else if([login to view URL]().getActiveSheet().getName() == '[login to view URL]'){ var searchString = [login to view URL](source_row, unique_col).getValue(); var columnValues = [login to view URL](2, unique_col, [login to view URL]()).getValues(); var searchResult = searchTheArray(columnValues, searchString); if(searchResult != -1 && source_col != 1) { [login to view URL](searchResult + 2, source_col).setValue([login to view URL](source_row, source_col).getValue()); } if(checkbox_col == source_col) [login to view URL](source_row); }else if(checkbox_col != source_col && [login to view URL]().getActiveSheet().getName() == 'Build Email List'){ var searchString = [login to view URL](source_row, unique_col).getValue(); var columnValues = [login to view URL](2, unique_col, [login to view URL]()).getValues(); var searchResult = searchTheArray(columnValues, searchString); if(searchResult != -1 && source_col != 1) { [login to view URL](searchResult + 2, source_col).setValue([login to view URL](source_row, source_col).getValue()); } } function searchTheArray(ary, key){ for (i = 0; i < [login to view URL]; i++) { for (n = 0; n < ary[i].length; n++) { if (ary[i][n] == key){ return i; } } } return -1; } }
Kitambulisho cha mradi: 18039878

Kuhusu mradi

3 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
$40 USD ndani ya siku 1
4.7 (29 hakiki)
5.1
5.1
3 wafanyakazi huru wana zabuni kwa wastani $33 USD kwa kazi hii
Picha ya Mtumiaji
Hello sir I will resolve your issue soon, please reply soon for start work, Thanks
$50 USD ndani ya siku 1
5.0 (184 hakiki)
6.4
6.4
Picha ya Mtumiaji
I am ready to start it Thanks
$10 USD ndani ya siku 1
4.4 (109 hakiki)
6.0
6.0

Kuhusu mteja

Bedera ya UNITED STATES
Waco, United States
4.7
64
Njia ya malipo imethibitishwa
Mwanachama tangu Feb 13, 2009

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.