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()
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)
[url removed, login to view](row,googleCalendarIndex,1,1).setValue(eventId);
24 freelancer đang chào giá trung bình $36/giờ cho công việc này
Project: Google Sheet Script Development Skills: PHP, Wordpress, Ruby on Rails, Laravel Experience: 11 Years Expertise: Website Development Team Size: Dedicated Programmer
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.