Best answer

Url to html

  • 1 November 2020
  • 4 replies
  • 209 views

Userlevel 1

Hello

I am trying to pass a url from cognitoform to google sheets. How can use the formatter to pass the url in the format <a href="https://xxx">View</a>

 

Many thanks

B

icon

Best answer by andywingrave 2 November 2020, 09:52

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

You don’t need to a Formatter step.

You’ll need to map the desired data point {{URL}} from the Cognito Forms trigger to the HTML.

<a href="{{URL}}">View</a>

Userlevel 7
Badge +9

Hello! Just to expand on what Troy has said here. 

Troy is correct that you can add a URL into your row in the following way: 

<a href="{{URL}}">View</a>

However you absolutely will need a formatter step if you want to encode special characters as part of your URL, and for that you can use the “URL encode step” as shown below:

Here we want to encode special URL characters

 

Userlevel 1

Fantastic  !!! Thanks Guys!!. Yes, I would want to encode special characters.

Bijou

Userlevel 1

Also for google sheets the syntax(formula) is =HYPERLINK("URL","TEXT")

Cheers

Bijou