Find Jobs
Hire Freelancers

Resolve script not running properly for multiple items selected quickly

$10 USD

进行中
已发布超过 5 年前

$10 USD

货到付款
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; } }
项目 ID: 18039878

关于此项目

3提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
$40 USD 在1天之内
4.7 (29条评论)
5.1
5.1
3威客以平均价$33 USD来参与此工作竞价
用户头像
Hello sir I will resolve your issue soon, please reply soon for start work, Thanks
$50 USD 在1天之内
5.0 (184条评论)
6.4
6.4
用户头像
I am ready to start it Thanks
$10 USD 在1天之内
4.4 (109条评论)
6.0
6.0

关于客户

UNITED STATES的国旗
Waco, United States
4.7
64
付款方式已验证
会员自2月 13, 2009起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。