cycle for on google script

€8-30 EUR

完了済み

投稿日:

6年以上前

€8-30 EUR

完了時にお支払い

I have created this script for update some data to MySql function PogliolaToWeb() { var conn = [login to view URL]("jdbc:****); var stmt = [login to view URL](); var ss = [login to view URL](); var sheet = [login to view URL]("CodeFix"); var data = [login to view URL]().getValues(); //var data = [login to view URL]('D2'); for (var i = 0; i < [login to view URL]; i++) { var sql = "UPDATE oc_product SET quantity_pg = quantity_pg +" + data[i][6] +" WHERE product_id =" + data[i][3]; var count = [login to view URL](sql,1); } [login to view URL](); [login to view URL](); } but the list of products to update has some fields empty so, i have to skip these fields and continue after (where there are already field filled), otherwise the cylce for will be interrupted. Look [login to view URL]

Google App Engine

JavaScript

プロジェクト ID: 15092863

プロジェクトについて

6個の提案

リモートプロジェクト

アクティブ 7年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@AnisInfoTech

Just 5 min work, give me the script and will fix that right away. All you need to add a check for data[i][3].

€13 EUR 1日以内

5.0

(16 レビュー)

5.5

この仕事に6人のフリーランサーが、平均€25 EURで入札しています

@mohamedkaram93

Hi there! I will be happy to help you with that one. I have checked your screenshot and I understand your requirement. When the script iterates over the rows in the sheet, it will skip empty rows and move into the next ones. I will be happy to address any of your questions! Sincerely, Mohamed

€24 EUR 1日以内

5.0

(36 レビュー)

5.3

@aanvikm

Hello Sir, I believe I can help you with this script. Could you please open chat to discuss. Thanks Aanvik

€34 EUR 1日以内

5.0

(2 レビュー)

5.0

@ioanaprof

Dear Sir or Ms. I am John, pleased to meet you. I'm well experienced in Google Apps Script and G Suite. Please, take a look at my portfolio in my profile. All your requirements are achievable. Thank you for your time ! John

€23 EUR 1日以内

5.0

(23 レビュー)

5.0

@MohsanEijaz

I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz

€30 EUR 1日以内