How to make a button that will open a URL in the browser

[Sylvie Dupont]

This works:

<a href='https://www.parasql.com' target='_blank'>Go</a>

But this does not work:

<a href='@value(MyTable.MyFieldURL)'='_blank'>Go</a>

When I click on it, it opens a new Window in my browser and give me a 404 Not Found on this server error.

Here's what it's always written in the address:

https://www.parasql.com/'whatever address is in the field'

Thank you.

[ParaSQL Support]

Per the ParaSQL documentation, @value() returns a single quoted string if referencing a character field. 

Usage examples:

WRONG:

<a href='@value(MyTable.MyFieldURL)'  target='_blank'>Go</a>

CORRECT:

 <a href=@value(MyTable.MyFieldURL)  target='_blank'>Go</a>

The @value() is substituted with a string within single quotes, therefore it should not be quoted.

[Sylvie Dupont]

Knew it was something really stupid! Thanks a lot! :-)

[Sylvie Dupont]

And if I want it like the other buttons? (a basic one)

I've tried this (it does anything on click):

<div class='BasicButton' onclick="

var a = document.createElement('a');

a.href = @value(MyTable.MyFieldURL) target='_blank';

a.click();

">Go</div>

Thank you.

[ParaSQL Support]

Try this:

<div class='BasicButton' onclick="
var a = document.createElement('a');

a.href = @value(MyTable.MyFieldURL);
a.target = '_blank';
a.click();
">Go</div>