Find Jobs
Hire Freelancers

Google Sheets Script

$10-30 USD

Completed
Posted over 3 years ago

$10-30 USD

Paid on delivery
Create a script that will open a form in google sheet that will allow someone to add data to the sheet. The script will need to allow a user to find information in a row by searching all the sheets in the google sheet. The script will also need to allow someone to change the data after the search The script will allow someone to add new data to the sheets, The values added will be on the next empty row based on if column A is empty. and column I data will determine what sheet to add it to. Here is the list of columns and the formatting needed. Column cell Number, Name, & format A. Hostname (Text Field) B. IP Address (number field, format ***.***.***) remove starting 0s, is if entered 192.168.001.001= [login to view URL] C. IP Address II (number field, format ***.***.***) remove starting 0s, is if entered 192.168.001.001= [login to view URL] D. Service Tag/Serial # (Text Field) E. Dock Service Tag (Text Field) F. Dock MAC Address (Text field, format **:**:**:**:**:**) G. MAC Address (Text field, format **:**:**:**:**:**) H. Location (Drop Down list) I. Dept (Drop Down List, this list will choose the sheet as well as add as data in the cell) J. Domain Operating System Drop Down List K. User Name (Text Field) L. Model Drop (Down List) M. Monitor Model (Text Field) N. Monitor Service Tag (Text Field) O. Bitlocker PIN (number Field) P. Notes (Text Field) The dropdown fields can be collected on a seperate sheet. I also need a place to be able to change the google sheets path, and change /add sheets names, and add/ change dropdown items.
Project ID: 27786320

About the project

5 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi there, I am an expert in Google App Script and automation services. I can develop the forms as required. The forms will have options for adding, searching and editing entries and the search will be for all workbooks in the current sheet. To get started, send me a message and I would love to get involved in your development project. Thanks for your time and consideration.
$60 USD in 2 days
0.0 (0 reviews)
0.6
0.6
5 freelancers are bidding on average $56 USD for this job
User Avatar
Hi, Greetings! ✅checked your project details: Google Sheets Script ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$70 USD in 2 days
5.0 (1 review)
4.3
4.3
User Avatar
Hi employer, I have gone through your description and understand your requirement to create form in excel allowing user to enter data as per the required format set. I have 2 years experience in google scripting and developed several projects in automating email alerts, payment gateways on they fill the form and such items. I can even develop customized as per your requirements. Please message so that we can proceed further regards rana
$48 USD in 2 days
5.0 (1 review)
1.7
1.7
User Avatar
I can help you build your script by using google sheets API. Whatever searching and updating operations you want can be implemented. I can provide it a simple user interface to interact with. The budget you posted was low according to the work you require. I'm a software engineer and have done such type of projects before and one very recently. Let's chat to discuss more.
$50 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Kill devil hills, United States
5.0
30
Payment method verified
Member since Nov 15, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.