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
Best answer
Url to html
- Beginner
Best answer by andywingrave
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:
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:
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
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>
+9- Zapier Solution Partner
- Answer
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:
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.