Google Sheets script for keeping tab on performed services
$10-30 USD
Imekamilika
Imechapishwa about 5 years ago
$10-30 USD
Kulipwa wakati wa kufikishwa
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]
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 ndani ya siku 1
4.9 (5 hakiki)
3.1
3.1
3 wafanyakazi huru wana zabuni kwa wastani $27 USD kwa kazi hii
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
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