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

Selesai
Disiarkan hampir 5 tahun yang lalu

$10-30 USD

Dibayar semasa penghantaran
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!
ID Projek: 19586625

Tentang projek

6 cadangan
Projek jarak jauh
Aktif 5 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
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 dalam 1 hari
4.9 (279 ulasan)
6.8
6.8
6 pekerja bebas membida secara purata $53 USD untuk pekerjaan ini
Avatar Pengguna
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 dalam 1 hari
4.9 (106 ulasan)
6.7
6.7

Tentang klien

Bendera UNITED STATES
Tallahassee, United States
5.0
2
Kaedah pembayaran disahkan
Ahli sejak Mei 24, 2018

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.