sedang Berlangsung

Resolve script not running properly for multiple items selected quickly

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;

}

}

Keahlian: JSON, PHP, Scripting

Lihat lebih lanjut: grant execute any external script, google script debug, sql execute external script, how to solve browser compatibility issues in javascript, google script logger not working, javascript cross browser compatibility issues, google script logger.log not working, logger.log not working, add multiple items oscommerce, server script running, summing multiple items excel, zen cart reduced shipping multiple items, paypal button php class form multiple items, multiple attributes multiple items oscommerce, zen cart shipping multiple items help, add multiple items osc, php script flash game multiple players, multiple items html paypal shopping cart, adding multiple items vector java, adding multiple items oscommerce

Tentang Pemberi kerja:
( 64 ulasan ) Waco, United States

ID Proyek: #18039878

Diberikan kepada:

$40 USD dalam 1 hari
(29 Ulasan)
5.1

3 freelancer menawar dengan rata-rata $33 untuk pekerjaan ini

microwebtechs

Hello sir I will resolve your issue soon, please reply soon for start work, Thanks

$50 USD dalam 1 hari
(184 Ulasan)
6.4
jonyahmed105

I am ready to start it Thanks

$10 USD dalam 1 hari
(109 Ulasan)
6.0