Find Jobs
Hire Freelancers

Google Sheets script for keeping tab on performed services

$10-30 USD

Completed
Posted about 5 years ago

$10-30 USD

Paid on delivery
Currently most of our customers buy discounted services via another site. They either buy 5 services called "Städabonnemang" or something else, which always is 1 time. We keep tab on performed services manually in the sheet "Utförda städningar" and our customer register is "Kundregister". Since our customers buy either 1 or 5 services occasions, we need to keep tab on how many services they have used. All performed services are already automatically sent to our sheets, so what we need is a script that says how many times a customer has had services. For this we need this in the script: 1. (In Kundregister sheet) The customer must have given a discount code "LD-kod". [login to view URL] 2. (In Kundregister sheet) Check if the customer has bought 5 times (Städabonnemang) or 1 time (anything but Städabonnemang) [login to view URL] 3. By using the name or email address of that row (in Kundregister) we need to check in the performed services sheet (Utförda städningar) how many services this particular customer has had. Each new performed service is a new row in this sheet. In this example the customer has 4 more rows above what we can see and therefore this service is her 5/5. [login to view URL]
Project ID: 18743746

About the project

3 proposals
Remote project
Active 5 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, I can achieve this through a combination between Google Sheets formula and a script. The formula - on "Kundregister" sheet - to identify the customers that we need to track. Then the script - on "Utförda städningar" sheet - to add how many services this particular customer has had. I have much professional experience with Google Sheets - formulas and scripts. My experience on this platform is still little but my last project here was with regards to writing a script about a Google Sheets functionality - you can check my profile for the positive review.
$25 USD in 1 day
4.9 (5 reviews)
3.1
3.1
3 freelancers are bidding on average $27 USD for this job
User Avatar
Hi. My name is Anne and I am thrilled to submit a bid for the fulfillment of your excel project. I have carefully read your project brief and thoroughly looked through all the links and I understand exactly what you need and how you need the files arranged in a sheet. This is a work I can carry out in 24hours. Working with me you can rest assured that you have a good freelancer working tirelessly to help you achieve your goals. I anticipate your response as I would look forward to working with you. Best regards
$30 USD in 1 day
4.6 (1 review)
1.2
1.2
User Avatar
hello How are you? I hope you are fine. I have read your request and I would love to work with your requirements. I have already put a thought on your design and would love to explain it to you through words or through graphics (for your better understanding). In addition to that, I will also provide unlimited revisions which means I will be working for you until you get satisfied. I am so excited to work with and to work on the concept that I have already in mind. If any question?. Don’t hesitate to ask or contact me back. Looking forward to work with you… If interested, open PMB so we can discuss the project. i am waiting for your replay Best wishes NAJAM US SAQIB
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWEDEN
Stockholm, Sweden
5.0
8
Payment method verified
Member since Jan 14, 2019

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.