Completed

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

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!

Skills: Excel, Google App Engine, Javascript

See more: google.script.run.withsuccesshandler example, google apps script web app example, google apps script html form, google apps script call function, google sheets script, google script parameters, google script help, google apps script html service example, bash script set proxy, perl script parse user input, simple javascript user input calculations, javascript sample calculate user input, logon script prompt user input, javascript decimal places user input, write javascript program allows user input integers, user input login script processing, javascript user input url redirect, photoshop user input javascript, reading user input javascript calculations, send user input zip code google maps javascript

About the Employer:
( 2 reviews ) Tallahassee, United States

Project ID: #19586625

Awarded to:

mrbrave

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 woul More

$30 USD in 1 day
(237 Reviews)
6.7

11 freelancers are bidding on average $49 for this job

BaNgan

Hi, I can use Google Apps script on these points above, via the onEdit function to detect when an checkbox is checked/unchecked The price is to cover all the details above Thanks Ngan Le

$133 USD in 7 days
(265 Reviews)
7.2
Mickelson

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. Unt More

$55 USD in 1 day
(67 Reviews)
6.2
bluebear1888

I am web and app program Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer to feel the greatest satisfaction with low price. If you want to dev More

$25 USD in 1 day
(17 Reviews)
4.1
alkajain2906

Greetings,
Thank you for posting a Job. I WILL DO THIS AS PER YOUR REQUIREMENT AND EXPECTATIONS. With the experience of over 300+web development projects including ANDROID, IOS, WEBSITES, WEB APPLICATIONS AND SOFTWARE More

$25 USD in 1 day
(13 Reviews)
4.0
softtronicstech

I read the requirements. $150 is the minimum amount for this to be done correctly. here are some of my demos added 3rd party api to googlesheets [login to view URL] send emails from sheets More

$150 USD in 7 days
(6 Reviews)
3.7
ivandavid33

Hi, there! I am Anton from Russia. I am very interested in your project as I have enough skills and experience with Google App Script and original JavaScript. I have already developed some extensions for Google Shee More

$25 USD in 1 day
(3 Reviews)
2.3
Shashicertain

We are a custom business solution provider specialized in quality Cloud development powered by ML, AI and other cutting edge technologies. In the past year, we’ve worked with industries in various domains such as More

$30 USD in 1 day
(0 Reviews)
0.0
stackcru

We can take care of the development and designing of your mobile app and it will be done without any hurdle with good quality. Quality is always on a top priority for us. The app will be developed in React Native. F More

$25 USD in 15 days
(0 Reviews)
0.0
AlexanderPGR

~~~ Very interested to me! ~~~ Hi, dear! Feel contact me for these kinds of projects. I will provide you the best result on time. I am waiting for your message to have a detail discussion. Thanks.

$20 USD in 1 day
(1 Review)
0.0
Invadergroup

Invaders is a group of independent professional writers and website developer and scholars from everywhere throughout the world. Together, we give best quality aid to secondary school, undergraduate, Masters and Ph.d More

$25 USD in 1 day
(0 Reviews)
0.0