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

Teljesítve
Kiadva ekkor: majdnem 5 évvel ezelőtt

$10-30 USD

Teljesítéskor fizetve
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!
Projektazonosító: 19586625

A projektről

6 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
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 napon belül
4,9 (279 értékelés)
6,8
6,8
6 szabadúszó adott átlagosan $53 USD összegű árajánlatot erre a munkára
Felhasználó avatár
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 napon belül
4,9 (106 értékelés)
6,7
6,7

Az ügyfélről

UNITED STATES zászlója
Tallahassee, United States
5,0
2
Fizetési mód hitelesítve
Tagság kezdete: máj. 24, 2018

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.