Find Jobs
Hire Freelancers

Javascript via Google Apps Script a set of actions in response to user input with a Google Sheet -- 2

$10-30 USD

Suoritettu
Julkaistu lähes 5 vuotta sitten

$10-30 USD

Maksettu toimituksen yhteydessä
Hi, we are in need of an experienced Google Apps Script developer (JavaScript) that can enhance current tools that we use on Google Sheets. There are 4 main objectives that we need to achieve with this task: 1. Document name: “Template: Checklists” Tab: “Annual” In the Sheet titled "Template Checklist", whenever a check box is checked in the "Annual (One Time Monthly w/ Date)" section, to record the day of the month that it has been checked on. So if today is May 12 2019, we would expect a "12" to appear under the "May" column next to the checked box. See “Image one” for an example. 2. Document name: “Template: Checklists” Tab: “Shipping” Once a checkbox is checked, the timestamp will automatically be added below the checkmark in AM/PM format. However, we would like the timestamp to also be created in a “Note” and also in a “comment” format for every single check mark. See “Image Two” for an example. 3. Document name: “Property Management (Accounts / Resources)” Tab: “Property Management - Checklist” Section: Last Reviewed / Complete Date Please have the document update the date automatically of each box (B3:B10) next to the check boxes (A3:A10) each time the checkbox is checked. So if A3 was checked on 5/13/2019, please have the B3 value update to 5/13/2019. See “Image Three” for an example. 4. Document name: “Property Management (Accounts / Resources)” Tab: “Property Management - Checklist” Section: Last Reviewed / Complete Date Please edit the AppScript so that the cell next to the checked box updates with a timestamp, every time someone edits the “Last Reviewed / Complete Date” date values. (Range B3:B10) So B12 should update automatically to the newest value in any of the range of B3:B10 everytime B3:B10 is edited. See “Image Four” for an example. Whomever is retained for this project will have access to the spreadsheets in question. Thank you!
Projektin tunnus (ID): 19586625

Tietoa projektista

6 ehdotukset
Etäprojekti
Aktiivinen 5 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
HI, There's no images attached for review in project's descriptions. Please send for a review. I have good experience in developing Google Script and can complete the tasks within couple of hours. Though i would say final timing after looking at the images and spreadsheets. Thanks
$30 USD 1 päivässä
4,9 (279 arvostelua)
6,8
6,8
6 freelancerit tarjoavat keskimäärin $53 USD tätä projektia
Käyttäjän avatar
Dear my employer! I checked your project carefully. I have a deep understanding of the problems you are going to realize in your project. They are not so difficult for me with 12 years of app development years. Until this time, I have been working on development while considering credit as the best. If you hire me, I promise to give you the greatest service. If you want to conceive more ideas and make it happen, give me a chance. Go ahead and give me a chart.
$55 USD 1 päivässä
4,9 (106 arvostelua)
6,7
6,7

Tietoja asiakkaasta

Maan UNITED STATES lippu
Tallahassee, United States
5,0
2
Maksutapa vahvistettu
Liittynyt toukok. 24, 2018

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.