Find Jobs
Hire Freelancers

Simple Google Sheets + macro or apps script order form

$10-30 USD

Completed
Posted 5 months ago

$10-30 USD

Paid on delivery
I have a simple order form with 5 columns of data. Item, Description, unit price, quantity, total price. I need the sheet to have an order submit button that will: Send a copy by email to addresses listed in the google sheet. Create a copy of the order form as a new file along with the current date and the name of the customer (stored in cell A1) and clear out the order form for the next submission. Should be super simple. I need this to function when shared with another user, not just on my own google account, but when shared or given access to an anonymous user.
Project ID: 37525702

About the project

13 proposals
Remote project
Active 5 mos 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
Hello! My name is Basanta Kumar and I am a native of Odisha, India. I have extensive experience in various domains such as finance and accounting, web scaping and tableau. I understand that you are looking for someone to create a simple order form with five columns of data that can send copies by email to addresses listed in the Google Sheet and create a copy of the order form as a new file along with the current date and the name of the customer stored in cell A1. I believe that I am the perfect fit for this project because of my extensive experience in various domains such as Excel (advanced formula), VBA/MACROS, Ms Access, Python and more. This expertise will be invaluable when it comes to creating an effective macro or app script order form solution.
$20 USD in 1 day
5.0 (3 reviews)
1.1
1.1
13 freelancers are bidding on average $23 USD for this job
User Avatar
Hi, I'm interested in your requirement. I have good experience of web development with Google Apps Scripts and Google form. We can discuss further on chat. Thanks!
$30 USD in 1 day
5.0 (19 reviews)
5.0
5.0
User Avatar
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
$30 USD in 4 days
5.0 (8 reviews)
3.5
3.5
User Avatar
Hello Eric B., I would like to grab this opportunity and will work till you get 100% satisfied with our work. Please come over chat and discuss your requirement in a detailed way. Faheem
$10 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I've checked your project description right now. I really excite for your project purpose. Because I feel very confidence in your project and I can finish project asap in according to your requirements. Please contact me for more discussion. Thanks for job posting.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I saw your project and I think I am the perfect person for this job. With my extensive experience in JavaScript and digital marketing, I am confident that I can create a macro or apps script order form that will fulfill your needs. My skillset includes designing captivating visuals and branding solutions as well as producing responsive and user-friendly websites. Plus, I have a strong proficiency in HTML, CSS, JavaScript and various web frameworks which will be instrumental in building the required sheet. I understand how important it is for you to have the order form function when shared with another user without issue, so I will make sure that everything is taken care of before we start work on the project.
$18 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Eric B., I am Kazi R., a JavaScript developer with 3 years of experience. I have carefully read the requirements for the project and I am confident in my ability to deliver a solution. To create the order form, I will use Google Sheets along with Google Apps Scripts. I will add an order submit button that will send a copy of the order form to the email addresses listed in the sheet. Additionally, I will create a new file with the current date and the customer's name (stored in cell A1) as the file name. This new file will serve as a copy of the order form and the original form will be cleared for the next submission. To ensure that the functionality works for shared or anonymous users, I will implement the necessary permissions and access controls. This will allow anyone with access to the form to submit orders and receive copies via email. I would like to connect with you in chat to discuss your project in more detail and provide you with my portfolio. I am confident that I can deliver a solution that meets your requirements. Regards, Kazi R.
$30 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Lakewood, United States
5.0
32
Payment method verified
Member since Apr 29, 2017

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.