Find Jobs
Hire Freelancers

google sheets script help

$25-50 USD / hour

Cerrado
Publicado hace más de 7 años

$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); };
ID del proyecto: 12295073

Información sobre el proyecto

22 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
22 freelancers están ofertando un promedio de $36 USD /hora por este trabajo
Avatar del usuario
Project: Google Sheet Script Development Skills: PHP, Wordpress, Ruby on Rails, Laravel Experience: 11 Years Expertise: Website Development Team Size: Dedicated Programmer
$41 USD en 10 días
4,7 (239 comentarios)
9,2
9,2
Avatar del usuario
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 en 40 días
4,9 (191 comentarios)
8,6
8,6
Avatar del usuario
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 en 2 días
5,0 (930 comentarios)
8,0
8,0
Avatar del usuario
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 en 10 días
4,9 (90 comentarios)
6,8
6,8
Avatar del usuario
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 en 10 días
4,8 (54 comentarios)
7,0
7,0
Avatar del usuario
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 en 5 días
5,0 (59 comentarios)
6,8
6,8
Avatar del usuario
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 en 10 días
5,0 (27 comentarios)
7,0
7,0
Avatar del usuario
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 en 2 días
4,9 (82 comentarios)
6,0
6,0
Avatar del usuario
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 en 10 días
4,8 (17 comentarios)
5,9
5,9
Avatar del usuario
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 en 40 días
4,6 (49 comentarios)
5,3
5,3
Avatar del usuario
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 en 10 días
4,9 (27 comentarios)
5,1
5,1
Avatar del usuario
A proposal has not yet been provided
$27 USD en 20 días
5,0 (1 comentario)
0,5
0,5
Avatar del usuario
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 en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I would lie to work on this project as my skills match with job requirement. I can perform this task accurately and quickly. Thanks Regards, Zain
$25 USD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
0,0
0
Miembro desde dic 6, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.