Google sheet

Lezárva Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Lezárva Kiszállításkor fizetve

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.

Excel JavaScript

Projektazonosító: #18055049

A projektről

13 ajánlat Távolról teljesíthető projekt Utoljára aktív: 5 évvel ezelőtt

13 szabadúszó tett átlagosan 55$ összegű árajánlatot erre a munkára

KulfiSoftwares

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 Továbbiak

$150 USD 3 napon belül
(268 vélemény)
7.4
karandeepsingh2

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 yo Továbbiak

$15 USD 1 napon belül
(1 Visszajelzés)
1.8
najeebtiwana

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 1 napon belül
(0 vélemény)
0.0
anupam1004

i have dine verious projects of such type.i am new to freelancer app but hbe done many sich works before.

$20 USD 1 napon belül
(0 vélemény)
0.0
pavitarsingh2962

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 Pro Továbbiak

$25 USD 1 napon belül
(0 vélemény)
0.0
goutam6863

100 % satisfaction guaranteed

$15 USD 1 napon belül
(0 vélemény)
0.0