cycle for on google script

€8-30 EUR

Completed

Posted

over 6 years ago

€8-30 EUR

Paid on delivery

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

Project ID: 15092863

About the project

6 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 1 day

5.0

(16 reviews)

5.5

6 freelancers are bidding on average €25 EUR for this job

@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 in 1 day

5.0

(36 reviews)

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 in 1 day

5.0

(2 reviews)

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 in 1 day

5.0

(23 reviews)

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 in 1 day