google sheets script help

$25-50 USD / hour

Ditutup

Disiarkan

lebih dari 7 tahun yang lalu

$25-50 USD / hour

I use Appsheets to imput information to my google sheet. The google sheet then has a script that creates a calendar event, and updates the calendar event if edited on the sheet. The problem lies in the trigger "onedit" which doesn't recognize the Appsheet update and therefore doesn't run if the Google Sheet is updated through Appsheet. I have read on the internet that there is an onchange trigger, but can figure out how to make that work. Below is the script, and the error is getRow comes back undefined. Can you write a more detailed script to find the last edited row. /* if a cell is edited in the sheet, get all the data of the corresponding row and create a new calendar event (after deleting the old event) by calling submitToGoogleCalendar() */ function dataChanged(event){ var sheet = [login to view URL](); var row = [login to view URL](); var eventId = [login to view URL](row,googleCalendarIndex,1,1).getValue(); var eventId = submitToGoogleCalendar(getSheetData(sheet,row),eventId) if(eventId!=null) [login to view URL](row,googleCalendarIndex,1,1).setValue(eventId); };

Software Architecture

ID Projek: 12295073

Tentang projek

22 cadangan

Projek jarak jauh

Aktif 7 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

22 pekerja bebas membida secara purata $36 USD/jam untuk pekerjaan ini

@technosystem

Project: Google Sheet Script Development Skills: PHP, Wordpress, Ruby on Rails, Laravel Experience: 11 Years Expertise: Website Development Team Size: Dedicated Programmer

$41 USD dalam 10 hari

4.7

(239 ulasan)

9.2

@r4rony

Hello Client Greetings..........!! We are web based Development Company. We have been nominated in Top 100 web Vendors 2013. We have experts available on various technologies Magento, Wordpress, Joomla, Drupal, CakePHP,Laravel, Codeigniter, Zend, PHP/MySQL, etc. Highlights about our company ----------------------------------------------- -100% Client Recommendations & Satisfaction. -50+ skilled full time developers/designer -Always work with milestones & release phases (Pay only when you happy) -More than 50% client get back to us for repeat business -Big portfolio of work (Please have a look at our portfolio, for more please contact us) We have designed numbers of websites and mobile applications for companies of all sizes. Our strategy for project development is anchored in a phased approach. This lets us establish a clear set of goals that ensure the quality of work is maintained throughout the entire development process for 100% client satisfaction. *** Additional Benefits *** {1} For Designing projects, we provide UNLIMITED REVISIONS until the client's utmost satisfaction {2} For Developing project, we facilitate Quality Analysis and Bug Testing {3} 24x7 Support via pmb Kindly provide your feedback over this. Let us discuss. Thanks Manisha

$25 USD dalam 40 hari

4.9

(191 ulasan)

8.6

@cgullapalli

Hi, I am good at Google Scripts. I would like to see, why it is not functioning. Can u plz give me access to the sheet to work and explore more. Looking forward to discuss in the chat.

$26 USD dalam 2 hari

5.0

(930 ulasan)

8.0

@dghq123

Hi there.. I have read your project details completely and willing to do it for you... Check my recent reviews for our quality work on on time delivery :) Please inbox and we can discuss about project and I will revise my bid once provided with full specifications...

$41 USD dalam 10 hari

4.9

(90 ulasan)

6.8

@prashushinde9

We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore your needs, which will yield a clear picture of implementation phase. Prior undertaking project, I want to show demo of the work done previously. Apart from demo, I will be sharing following documentation which will turn your project into Quality and Successful delivery: - Technical Project Proposal - Designs - Flow chart for this Project - Execution plan

$51 USD dalam 10 hari

4.8

(54 ulasan)

7.0

@aanvikm

Hello Sir. I am an expert google developer and can help you with this script. Pls open chat to discuss more about this project. Thanks Aanvik

$30 USD dalam 5 hari

5.0

(59 ulasan)

6.8

@Shopify

Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further on personal chat. Let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, I use to be online 24x7 on Freelancer so probably you will get a quick response from my end. Following are my Expertise Area: 1)PHP with CodeIgniter and Laravel Framework. 2)Node JS 3)Angular JS 4)Mobile App Development Thanks.

$41 USD dalam 10 hari

5.0

(27 ulasan)

7.0

@mdkass

Hello, This can't be done by the Change trigger. From google help: "An installable change trigger runs when a user modifies the structure of a spreadsheet itself — for example, by adding a new sheet or removing a column." but I can do it using an alternative way by using a time trigger. Regards.

$25 USD dalam 2 hari

4.9

(82 ulasan)

6.0

@RubyOnRail

Hello, Its a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work upon customization part, if we can proceed towards more discussion. I have gone through your project description and confident to accomplish your project. I am an individual developer and you will be working directly with me if we proceed work on this project. My key skills are - 1)Ruby 2)Ruby On Rail 3)Angular JS 4)Node JS 5)PHP with Codeigniter and Laravel Framework. Let's initiate our chat so we can proceed towards conclusion of this project scope and give it a start as soon as possible. Thank & Regards Prashant Shinde

$55 USD dalam 10 hari

4.8

(17 ulasan)

5.9

@nileshbakotiya

hii Thanks for the opportunity. - Creating modern and custom website designs - Mobile applications iOS and Android - Plugin and Components - Mobile and tablet friendly responsive sites - PHP -Laravel framework - Codeigniter framework - PHP and website security - Bitcoin and other cryptocurrencies - Other Bitcoin solutions. all types of CMS work done like joomla Wordpress prestashop opencart etc//... We beat deadlines and leave our clients completely satisfied. We have the skills you need, and we have the credentials, portfolio and client references to prove our abilities. Please spare a moment to discuss this project. Waiting for your message Thanks

$25 USD dalam 40 hari

4.6

(49 ulasan)

5.3

@cracken

Hi, I am competitive to this kind of task, can take good care of this project. In fact, I already done related to this job before. Let me know the best of your time so we can discuss further based on your requirements and we can move forward to the next step. Thanks, Joseph C Ocero

$48 USD dalam 10 hari

4.9

(27 ulasan)

5.1

@ahmedtaher2020

A proposal has not yet been provided

$27 USD dalam 20 hari

5.0

(1 ulasan)

0.5

@adi3006458

I am Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are looking for data entry or search work, I am the Right person for you. available 24-7. a trusted Freelancer give me a chance please

$27 USD dalam 10 hari