Find Jobs
Hire Freelancers

Google Sheet Modification with appscripts and triggers

$10-30 USD

Ditutup
Dibuat sekitar 5 tahun yang lalu

$10-30 USD

Dibayar ketika dikirim
I need an expert in google sheet scripts (Excel VBA) to add triggers and modifications to my workbook. Must know how to work google appscripts. To Do 1. Redo Protected cells and clear cells 2. On AM Sheets Col BO1 I need a triggered function that copies the VALUES ONLY from E1:AS47 (Triggered 9am of the same day). So 9am of Monday, MonAM BO1 gets VALUE COPIED to MonAM E1:AS47. Continues on to next sheets the next day 3. On PM Sheets Col BO1 I need a triggered function that copies the VALUES ONLY from E1:Z47 (Triggered 9pm of the same day). So 9pm of Monday, MonPM BO1 gets VALUE COPIED to MonPM E1:AS47. Continues on to next sheet the next day 4. Triggered lock function similar to previous sheets made. At 11am of Monday, MonAM locks and MonPM becomes editable. At 11pm of Monday, MonPM locks and TueAM becomes editable. Editable sheet with green color for easy viewing 5. On FriPM trigger A copy of Workbook is made. Name of Workbook is Workbook Name + Cell 2MonAM!B1. Data is cleared on Sheets 2MonAM to 2SunPM 6. On 2FriPM trigger A copy of Workbook is made. Name of Workbook is Workbook Name + Cell MonAM!B1. Data is cleared on Sheets MonAM to SunPM 7. On MonAM!B1 & 2MONAM!B1; is it possible to show the week that this sheet falls on eg. if it falls next week then MonAM!B1 should show "Jan28 to Feb3" (Mon to Sun format), and 2MonAM!B1 "Feb4 to Feb10". Ofcourse this has to change week per week so i suppose this can be added to part of the trigger Remove 1. Email Function and Button to send request request
ID Proyek: 18596755

Tentang proyek

9 proposal
Proyek remot
Aktif 5 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
9 freelancer menawar dengan rata-rata $54 USD untuk pekerjaan ini
Avatar Pengguna
Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. 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 and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Data Entry, Data Processing, Excel, Visual Basic, Visual Basic for Apps. Please ping me for more discussion.
$120 USD dalam 3 hari
4,9 (533 ulasan)
8,4
8,4
Avatar Pengguna
Hello, I am an Excel coder and I already finish 1 google sheet script with triggers to use on phone/tablet. I think I can do this task for you. Contact me and I can show you my result for a look. Thank you.
$30 USD dalam 10 hari
5,0 (233 ulasan)
6,6
6,6
Avatar Pengguna
Hello, It would be my pleasure to create the scripts for you and assign triggers to them. Actually I will show you how to add/modify triggers yourself as this is very easy. Please open a chat with me if you are interested. Kind regards, Sorin
$50 USD dalam 1 hari
5,0 (76 ulasan)
5,6
5,6
Avatar Pengguna
am not a random bidder... Please ping me if you are interested with my proposal and share more detail.. thank you..
$150 USD dalam 1 hari
4,9 (28 ulasan)
5,0
5,0
Avatar Pengguna
I have proficient knowledge of Google Apps Script and Google Sheets. I can do your work in 2-3 hours.
$15 USD dalam 1 hari
5,0 (1 ulasan)
1,5
1,5
Avatar Pengguna
Hi sir I am studying artificial intelligence in kings cornerstone international college Chennai in association with RMIT UNIVERSITY, Australia I can do this project best Waiting for your message sir.
$20 USD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hello, Google app script is pretty straightforward and I have worked on it quite a number of times. May I know the file that you want me to work on? I've been working on php, java script, python scripts and linux administration for more than 11 years. I always believe in giving my best in every single project and will ensure that you'll get top quality work from me. I hope to work with you and if you have further questions, do feel free to message me. Regards, Abel
$20 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi, Let's do it this way. You share the sheet with me, and I will do the script work and share it with you. You will not own the script until you pay me. This way, you can be satisfied with what you see, and then pay me. Also, I will need to do all the options you have asked for and it will take much time than you expect. The budget is short, to cover the freelancer project fee as well, I will need at least $55 in one milestone. And you can release it when you are satisfied with the file. Thanks Qunson
$55 USD dalam 5 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hello there I have expirience in making those kind of sheets. If Your interested in cooperation please contact me :)
$25 USD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED KINGDOM
London, United Kingdom
5,0
12
Memverifikasi Metode pembayaran
Anggota sejak Agu 28, 2015

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.