Find Jobs
Hire Freelancers

Google Sheet Scripting

$15-25 USD / hour

Selesai
Disiarkan lebih dari 7 tahun yang lalu

$15-25 USD / hour

I have a Google Spreadsheet with multiple sheets. I need a script that will take the user's cell position and lookup data from other sheets based on where the user clicks or hovers. Ideally, this could be written into a note on the cell the user has interacted with; alternatively it could be displayed in a box or sidebar. The example below shows a bit what I am looking for -- I can use functions (without scripting) to achieve one at a time, but need a script to go further. In the example, I experimented with two different ways to call the info from another sheet. Both reference the "Artist Compensation" cell in the A column as well as another further up. Columns D/E are produced using a QUERY; Columns F/G are using a FILTER. This works except for being able to change the query/filter based on user click/hover.
ID Projek: 10994173

Tentang projek

8 cadangan
Projek jarak jauh
Aktif 8 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Hello, There is no hover event on spreadsheet, nor a cell click event, user should click a button or a menu item in order to trigger the script function related to your query/lookup, is that OK?
$22 USD dalam 5 hari
4.9 (9 ulasan)
4.2
4.2
8 pekerja bebas membida secara purata $27 USD/jam untuk pekerjaan ini
Avatar Pengguna
Hello sir! My freelancer ranking is top 5th and i am full stack developer. I am interested in your project and I hope to work with you. I have enough experience with WEB developing for 7+ years. Client satisfaction is my top priority. I will complete your project perfectly in your deadline. I am ready to start the work, and it will be a great pleasure for me to work for you. Please get in touch. Looking forward to hear from you. Best Regards! - KCHG -
$41 USD dalam 10 hari
4.9 (130 ulasan)
8.3
8.3
Avatar Pengguna
Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i will prepare following things for you - Technical Project Proposal - Flow chart for this Project - Execution plan (Step by step procedure with explanation how and at what that we are going to execute a particular task)
$29 USD dalam 10 hari
5.0 (5 ulasan)
4.7
4.7
Avatar Pengguna
Hi, I can do your job but need to make a short chat discussion with you. let me know if possible for you. please let me know. You can check my profile and feedbacks of clients which itself I got from them . Hope they make some small help trust on me for your job. Profile url : https://www.freelancer.com/u/AltiuseCreaton.html Regards Rina
$34 USD dalam 110 hari
5.0 (4 ulasan)
3.8
3.8
Avatar Pengguna
Hello there! I think I understood what you need to do, but as far as I know, that functionality is not available to the custom scripts. There is no way to detect a "click" action by the user, let along hover, directly in the Google sheets interface. This kind of events are easily detected on the usual webpage through some JavaScript, but Google doesn't let the developers use it. Just to make sure, I understood you, you need to fetch the data from another sheet once user points to a particular item on the Expense list. If that is the case, you might need to think of some other way to implement it. If I misunderstood something, let's have a chat, and we will have it sorted. Cheers, Denis
$22 USD dalam 10 hari
5.0 (1 ulasan)
2.2
2.2
Avatar Pengguna
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end.
$29 USD dalam 10 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi,I have gone through your project description. I could be confident if we can proceed towards more discussion. I am an individual developer and you will be working directly with me if we proceed work on this project. My key skills are - 1)Ruby 2)Ruby On Rail 3)Angular JS 4)Node JS 5)PHP with codeigniter and Laravel Framework. Let's initiate our chat so we can proceed towards conclusion of this project scope and give it a start as soon as possible. Thank & Regards Prashant Shinde
$20 USD dalam 30 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. I can show you some examples of my work. Please contact me to discuss your project.
$22 USD dalam 10 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera UNITED STATES
Minneapolis, United States
5.0
2
Kaedah pembayaran disahkan
Ahli sejak Ogo 24, 2009

Pengesahan Klien

Pekerjaan lain daripada klien ini

Coding Javascript
$30-5000 USD
Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.