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

Færdiggjort
Slået op næsten 5 år siden

$10-30 USD

Betales ved levering
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!
Projekt-ID: 19586625

Om projektet

6 forslag
Projekt på afstand
Aktiv 5 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
Tildel til:
Brug 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 på 1 dag
4,9 (279 anmeldelser)
6,8
6,8
6 freelancere byder i gennemsnit $53 USD på dette job
Brug 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 på 1 dag
4,9 (106 anmeldelser)
6,7
6,7

Om klienten

Flag for UNITED STATES
Tallahassee, United States
5,0
2
Betalingsmetode verificeret
Medlem siden maj 24, 2018

Klientverificering

Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.