Find Jobs
Hire Freelancers

Script for Google Spreadsheet

€30-250 EUR

Finalizat
Data postării: circa 5 ani în urmă

€30-250 EUR

Plata la predare
I would like a script to copy the entire row of a document sheet into a sheet of another document when the first column puts a predefined value. When making further changes, I should copy my row again over the existing row. I have two different Google Spreadsheet tables. Table 1 and Table 2 In Table 1 I simulate product orders based on the information received by customers on the phone. If the order is concretized, in the first column choose the "approved" value and I would like to copy it in Table 2. I would like this copy to be done automatically, through a script, when I put the "approved" value. But when I subsequently modify the order in Table 1, it also changes automatically in Table 2. Also when I subsequently modify the order in Table 2, it also changes automatically in Table 1. When you start to fill cells from Table 1, I wish to automatically fill timestamp in column 2, with the date and time of starting filling, and when the first column I choose the "approved" value, I wish to automatically fill timestamp in column 2, with the date and time of choosing the "approved" value. The two timestamps do not change for later changes. When I choose "Approved" from the first column, I want to automatically fill in column 4, a "MS0000001" order number that grows from 1 in 1. Subsequent changes in Table 1 should be checked depending on the order number, if any, and if it exists, automatically copy the row back to Table 2. I mention that the lines to be copied are formulas and only their values ​​must be copied (withour format or formula). I mention that there are 4 different Table 1 that will be copied in a single Table 2. The order number will be different depending on the source table. I mention that the table will have thousands of rows and will have to be optimized to have a great workload and load speed and also to be pure code, not using third part apps.
ID-ul proiectului: 18780438

Despre proiect

26 propuneri
Proiect la distanță
Activ: 5 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
Acordat utilizatorului:
Avatarul utilizatorului
Hi, I have done many Google Spreadsheet scripts similar to the one you need and describe. I have much professional experience as a Data Analyst using mainly Excel and Google Sheets to automate reports. In addition, the last 2 projects I took over were exactly related to scripting in Google Spreadsheet - you can check the positive reviews in my profile. In addition, even once work is done and project is closed, I'll continue being available for a few days, if any bugs pop up. But my experience on this platform is still little, that's why for now my bid is lower.
€35 EUR în 2 zile
5,0 (5 recenzii)
3,6
3,6
26 freelanceri plasează o ofertă medie de €122 EUR pentru proiect
Avatarul utilizatorului
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
€220 EUR în 3 zile
4,9 (434 recenzii)
8,3
8,3
Avatarul utilizatorului
Hi, I am good at Google sheet script. Please share the google sheets link to review the data and the format. I can transfer the data to sheet2 from sheet1. However, reverse may not be possible, as sheet1 has formulas and they may overwrite with the values. Looking forward to discuss in the chat. -Chandra
€150 EUR în 3 zile
5,0 (983 recenzii)
8,2
8,2
Avatarul utilizatorului
Hello, i have develop many google app script to automate task, do you want trigger run something? can you please share the sheet link so that i can check and show you proof of concept? thanks!
€150 EUR în 3 zile
5,0 (291 recenzii)
7,7
7,7
Avatarul utilizatorului
Hello Gomy Music Team, I can write this googlescript of moving updated data into other sheet. I have read project brief and i can dothis work.. I have 5 years experience in google script programming. With Regards, Sai
€60 EUR în 3 zile
4,9 (452 recenzii)
7,6
7,6
Avatarul utilizatorului
Hi, I am Khoa with more than 7 years experience in web and cross-platform app development including Hybrid, PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, WordPress template & plugin, WooCommerce. I am able to write script to sync between table 1 and table 2 for automatically changing the Approved value, timestamp. Can I take a look at those 2 tables? I am ready to discuss and start now. If I am chosen for this project, I commit preparing the development site and updating project status daily or whenever you message me. Thank you for your consideration. I am looking forward to your reply. Sincerely, Khoa
€200 EUR în 5 zile
5,0 (107 recenzii)
7,5
7,5
Avatarul utilizatorului
Hi there,I am Google sheets expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
€133 EUR în 3 zile
4,9 (158 recenzii)
7,7
7,7
Avatarul utilizatorului
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews, they speak for themselves. Best regards
€100 EUR în 1 zi
4,9 (291 recenzii)
7,2
7,2
Avatarul utilizatorului
Dear client I ca make tthe google script for the automation of the process you mentioned. Kindly contact me for further details. Roy
€200 EUR în 3 zile
4,9 (436 recenzii)
7,3
7,3
Avatarul utilizatorului
Greetings! In the skills required section, only Excel is specified (and not Google Spreadsheet). If it is an Excel solution that you are looking at, I can definitely help. I understand the requirements - please share the files. I would come up with the Script to automate time stamp and Order Number update in Table 1 as well as Table 2 update based on Table 1. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi
€60 EUR în 2 zile
5,0 (217 recenzii)
7,0
7,0
Avatarul utilizatorului
HI, I will create a script in Google sheet, which will trigger on cell change. It will add new row or update existing row..whatever is required. I can complete the script within couple of hours. I am available right away to statr. My code will me pure google script code and should be good with large sheets. I like to discuss you how I will implement the structure. Thanks
€60 EUR în 1 zi
4,9 (281 recenzii)
6,9
6,9
Avatarul utilizatorului
Hello, I am experienced google script expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards Rina B.
€100 EUR în 3 zile
5,0 (121 recenzii)
6,6
6,6
Avatarul utilizatorului
Hi Nice to meet you. I have enough experience in python script. Below the libraries are I used in past project. selenium, pandas, matplotlib, lxml, beautifulsoup, scipy, and other useful libraries. I have written some automation and scraping, scientific scripts. Also have experience in google spreadsheet using their api. So I think I can help you in your project. Just let me know if you want start job. Regards. Lian
€150 EUR în 3 zile
4,9 (120 recenzii)
6,8
6,8
Avatarul utilizatorului
Hi I have gone through the requirements. Will do this script using Google App script. I'm available to start now. Please share additional details. Regards, Mohan
€55 EUR în 2 zile
5,0 (55 recenzii)
4,9
4,9
Avatarul utilizatorului
Dear Hiring Manager, I working since 10 years in web development. I have worked with so many API integrations of google. I have worked with gmail API, spreadsheet API, google map API, google drive API and many more. Thanks Ram Bagdi
€200 EUR în 3 zile
5,0 (18 recenzii)
4,8
4,8
Avatarul utilizatorului
Proficient knowledge of Apps Script to complete your task within a day. The code will be pure without using any third party apps. Please let me know when to start.
€30 EUR în 1 zi
5,0 (1 recenzie)
0,6
0,6
Avatarul utilizatorului
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do this job and give you an efficient job that will be very acceptable and presentable. I and my team work on web development and mobile apps and I can assure you that you will never be disappointed"
€208 EUR în 7 zile
0,0 (2 recenzii)
0,0
0,0
Avatarul utilizatorului
I’m quailed to work with documents, spreadsheets, and database. I always deliver my work on time. I like to finish my project before the specified deadline. I enjoy new challenges and use them as an opportunity to learn. Projects take priority and I will be sure to deliver to the best of my ability.
€155 EUR în 2 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
I promise that I can deliver your product within time. You will sure satisfied about my work. Error Prone work is my plus point
€111 EUR în 2 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
Here, you find a PERFECT MATCH..!! Regarding Your Requirements: - I have reviewed your requirements and it exactly falls under our area of skills and expertise. - We have worked on almost all the mentioned features and functionalities in our past projects. - Choosing us can prove to be the BEST decision because: > Developed more than 150 applications for iOS and Android. > 50+ website design and developed > Experience which leads to a clear understanding and on-time delivery > In-house teams of UI/UX designers, QA testers & brilliant developers. Assurance: Our enthusiastic teams will be always ready to provide their suggestions and recommendations regarding the project at any point of time. "Just give us a chance and we will surely amaze you with our work..!!" Thanks. Note: The current provided cost & timeline for the project is a placeholder and we will provide you precise estimated cost and timeline once we will have a clear scope of work.
€111 EUR în 2 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
I used to work in office work for more than 15 years. I am good at a typewriter, really like challenges and would like to learn everything. I used to work under pressure and tight deadline so I positively can finish the work in tight deadline.
€155 EUR în 10 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul ROMANIA
Iasi, Romania
5,0
10
Metoda de plată a fost confirmată
Membru din mar. 16, 2012

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.