I want to try and link a field to a Google doc.
I selected the field URL and added as an example,
Not the real linksโฆ
HYPERLINK(โhttps://docs.google.com/doc/d/1lr9LKXlHncVYqbHhUNvIRVEHpoOEw2shmttUeHq4huU/edit?usp=sharing","HOW TO CLEANโ)
I got the Hyperlink from using the sharing option and have set the sharing option to anyone can view.
This then gives me 2 fields one containing the URL and another one containing โHOW TO CLEANโ.
I thought it would give me a โHOW TO CLEANโ field that the user could click on.
UPDATE:
I think that the special characters in the google docs link would stop it from working so I did this.
HYPERLINK(CONCATENATE(โhttps://docs.google.com/doc/d/1lr9LKXlHncVYqbHhUNvIRVEHpoOEw2shmttUeHq4huU/edit?usp=",โsharingโ),"HO... TO CLEANโ)
But it didnโt fix the problem so I attempted this.
HYPERLINK(
CONCATENATE(
โhttps://docs.google.com/doc/d/1lr9LKXlHncVYqbHhUNvIRVEHpoOEw2shmttUeHq4huU/edit?usp=โ,
ENCODEURL(โsharingโ)
),
โHOW TO CLEANโ)
Now I am out of ideasโฆ
You havenโt explained how it doesnโt work. Where and how are you using this hyperlink?
It just shows a greyed out field with the url link therein. I canโt do anything with the field.
I want to be able to click on the link, which is called โHOW TO CLEANโ and be directed to the Google doc.
Where? Please post a screenshot.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |