Find Jobs
Hire Freelancers

Google Sheets script for keeping tab on performed services

$10-30 USD

Terminado
Publicado hace alrededor de 5 años

$10-30 USD

Pagado a la entrega
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]
ID del proyecto: 18743746

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
4,9 (5 comentarios)
3,1
3,1
3 freelancers están ofertando un promedio de $27 USD por este trabajo
Avatar del usuario
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 en 1 día
4,6 (1 comentario)
1,2
1,2
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SWEDEN
Stockholm, Sweden
5,0
8
Forma de pago verificada
Miembro desde ene 14, 2019

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.