Find Jobs
Hire Freelancers

Google Form / Google Sheets - Add Leading Zero on Form Responses

$10-30 USD

Completed
Posted about 8 years ago

$10-30 USD

Paid on delivery
Hello, I have a Google Form which users will fill out their telephone numbers in. The number must always start with a '0' and be no longer or shorter than '11' digits in length. One of the problems is by default when the form responses feed into a Google Sheet upon completion by default the zero '0' gets chopped off. Even though they would have entered it with the leading zero whilst completing the form. There also needs to be some validation where the number is no longer or shorter than '11' digits in length.
Project ID: 9749969

About the project

13 proposals
Remote project
Active 8 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
I have exp in Google form script. I can do this. I can automate the Google spreadsheet and form
$15 USD in 1 day
5.0 (1 review)
0.4
0.4
13 freelancers are bidding on average $20 USD for this job
User Avatar
Hi, I am working as a freelancer since 12 years and completed 1500 projects. I assure you 100% accuracy in the delivered work. I look forward to work with you. Please provide me an opportunity to get started and prove my skills. Thanks
$30 USD in 1 day
4.9 (170 reviews)
7.1
7.1
User Avatar
Can resolve this for you in 20 minutes. Extensive excel/vba experience in an reporting and analytics.
$25 USD in 0 day
3.9 (3 reviews)
3.4
3.4
User Avatar
I can build new better for exactly as you need by my codes not google form
$30 USD in 1 day
4.8 (5 reviews)
2.2
2.2
User Avatar
I can solve your problem because I am familair with such situations. Look no further, contact me lets discuss the detail and get your problem solved.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have over 15 years experience writing Excel spreadsheet solutions for business and personal use. I gather that you wish to have some way to take the data contained in a Google Sheet, replace the leading zeros and ensure the text is 11 characters, with any difference in length being validated, for example, text in red, or "INVALID" showing in the cell. Your proposal sounds easily achievable and I would be happy to collaborate with you in due course regarding the project. I hope to hear from you soon, Kind regards, Chris James
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello: I can successfully deliver your job for $10 within 2 days.
$10 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do it fast on excel spreedsheet. I had done something simmilar with polish PESEL numbers. I am a Excel trainer with more than 5 years of experience.
$15 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Worcestershire, United Kingdom
5.0
12
Payment method verified
Member since Oct 19, 2015

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.