Completed

Google Sheets script for keeping tab on performed services

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]

Skills: Excel, Excel Macros, Excel VBA

See more: google apps script, google sheets run script on click, google apps script share spreadsheet, google forms script editor, google apps script permissions, time driven trigger google sheets, google sheets script editor, google form submit trigger

About the Employer:
( 1 review ) Stockholm, Sweden

Project ID: #18743746

Awarded to:

DBoptimizations

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ädni More

$25 USD in 1 day
(3 Reviews)
1.6

5 freelancers are bidding on average $24 for this job

Anneanthony

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 ne More

$30 USD in 1 day
(1 Review)
1.2
apcheindian

Dear Sir, Please let me know additional details regarding your project. Looking forward to hearing from you. Best regards,

$15 USD in 1 day
(0 Reviews)
0.0
NAJAM5313

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 thr More

$25 USD in 1 day
(0 Reviews)
0.0
masudrana384141

i do this work i have 2 year [login to view URL] you give me the work i do my best,good accuracy and good quality .

$23 USD in 1 day
(0 Reviews)
0.0