Find Jobs
Hire Freelancers

Google sheet

$10-30 USD

Closed
Posted over 5 years ago

$10-30 USD

Paid on delivery
Script>Editable>Google Forms>Google Sheets The form will add values in the form of titles to the sheet. The part I need help with is a cross-referencing script that will input values from the form into a sheet as hyperlink values instead of plain text. So I think I need a script (using a sheet) that cross-references the value and inputs a hyperlink in the Google Sheet that I'm going to highlight and copy from. The script has to be something I can add to as I will be adding to the form so it has to be easy to (example) add the title to A1 and the link to A2 and with the script will create a hyperlink in a sheet that i'll copy from. I have no idea how to do this and I could probably learn how. Since it's an environment I need created, the rule/script will be the same, I just need an environment to work with that's plug and play. I'm sure there's more than one way to do this and I just want the one that's easy for me to work with and add to. I.e. An endless sheet with empty columns to put Titles and Links to or even just paste the hyperlink itself and the script trigger. How I use it: I create follow-up emails for customers. In the email, I paste links from a OneNote that are related to the convo I had with them. I'd like to be able to fill out a form as I'm talking to them that is actively creating a list of links so, at the end of our conversation, I can simply highlight the whole row from a google sheet and paste it in the email and hit send. I've been able to take care of all of that with the exception of the values from the sheet are only text. I can't figure out a way to make them automatically link. I'm not sure if I should have a script that creates the link at a point of cross-referencing or if a script could be written that will take hyperlinks from a separate sheet and place them in my first sheet based off of selections made from my google form. I'm open to all suggestions. I just need something I can add more and more hyperlinks to for pulling/cross-referencing. I don't need help with putting in the links because I can do that once I have the scripted environment.
Project ID: 18055049

About the project

13 proposals
Remote project
Active 5 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
13 freelancers are bidding on average $55 USD for this job
User Avatar
Expert at writing Google Apps script!! I can write the script to convert your Google form responses to hyperlinks as requested. ZERO ERROR GUARANTEED!! Please read my ~400 reviews. I am here to impress you with my work.
$150 USD in 3 days
4.9 (268 reviews)
7.4
7.4
User Avatar
I have read your project description properly and I know how to add hyperlinks to Google sheets using a script. the solution is Google App Scripts. Hire me and I will write a readable and easy to understand code for you to extend
$15 USD in 1 day
5.0 (1 review)
1.8
1.8
User Avatar
Hi, i am expert in data entry since 3 years. Now i am on freelancer.com to providing best services with reputable manners and have greater ability and best communication skill to communicate with reputable customers.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i have dine verious projects of such type.i am new to freelancer app but hbe done many sich works before.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello , I am Pavitar Singh , I am expert in Microsoft office and java script . I am ne on freelancer but last time I have done a job in JavaScript . Many JavaScript project have done from me . I do the JavaScript Project of with may great interest. If you are going to hire me I will show the portfolio . first you have to do some work from me . if you like , do all the work waiting your response... with regards..... Pavitar Singh
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
100 % satisfaction guaranteed
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Evans, United States
5.0
1
Payment method verified
Member since Oct 23, 2018

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.