Đã Đóng

google sheets script help

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 = [url removed, login to view]();

var row = [url removed, login to view]();

var eventId = [url removed, login to view](row,googleCalendarIndex,1,1).getValue();

var eventId = submitToGoogleCalendar(getSheetData(sheet,row),eventId)

if(eventId!=null)

[url removed, login to view](row,googleCalendarIndex,1,1).setValue(eventId);

};

Kĩ năng: Excel, Microsoft Access, PHP, Shell Script, Kiến trúc phần mềm

Xem nhiều hơn: i am looking for someone to write a google apps script in google sheets, script php google translation, script generator google maps, script display google calendar, script open google keyword, script translate google php, script code google earth picture excel, veda help script v35, script mysql google map, php script blocked google, script mini google search box, php script checking google positions, script php google maps, clone script php google map, script mysql google map cms

Về Bên Thuê:
( 0 nhận xét ) United States

ID dự án: #12295073

24 freelancer đang chào giá trung bình $36/giờ cho công việc này

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 / giờ
(159 Nhận xét)
9.2
A2Design

Hi, Nice project you have there, let us help you with it! Our team is Russian-Canadian. We code in PHP. Check our recent projects here [login to view URL] Here’s a little video about our team too! ht Thêm

$50 USD / giờ
(80 Nhận xét)
8.4
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, Thêm

$25 USD / giờ
(123 Nhận xét)
8.1
londonlance

We are a London (Shoreditch) based Fullstack dev studio. Following are some of our recent projects; [login to view URL] A social media post scheduler and manager for a startup from Silicon Valley, built us Thêm

$35 USD / giờ
(33 Nhận xét)
7.2
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 / giờ
(315 Nhận xét)
7.0
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 ne Thêm

$51 USD / giờ
(49 Nhận xét)
6.9
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 Thêm

$41 USD / giờ
(17 Nhận xét)
6.8
SevenStarInfo

Hello ! We want to discuss about your project as we have experience in it. What Differentiates us from the other freelancers : # Experience of more than 5 years in Unity 3D, Xcode, CoCoa 2d, Phonegap and major Thêm

$25 USD / giờ
(54 Nhận xét)
6.8
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 re Thêm

$41 USD / giờ
(61 Nhận xét)
6.4
AwaisChaudhry

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I wouldn't call myself a master but I do work smart and do not rest until I get the job done. Please feel free to ping me an Thêm

$41 USD / giờ
(38 Nhận xét)
6.5
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 Thêm

$25 USD / giờ
(75 Nhận xét)
5.9
$38 USD / giờ
(64 Nhận xét)
5.3
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 Thêm

$55 USD / giờ
(7 Nhận xét)
5.6
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 / giờ
(19 Nhận xét)
5.1
bestit4u

Hi, I am very interested in your job. I just saw your job description and got sure. I am a developer with over 6 years of experiences in PHP, ASP.NET, C, C++ & C# programming, Reverse engineering, Java, Ionic, Python Thêm

$41 USD / giờ
(5 Nhận xét)
4.5
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 framew Thêm

$25 USD / giờ
(30 Nhận xét)
4.6
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 Thêm

$48 USD / giờ
(14 Nhận xét)
4.4
$41 USD / giờ
(2 Nhận xét)
1.4
ahmedtaher2020

A proposal has not yet been provided

$27 USD / giờ
(1 Nhận xét)
0.5
$32 USD / giờ
(0 Nhận xét)
0.0