Page 1 of 1

Hashes in subforms

Posted: Mon Feb 19, 2018 3:13 pm
by agnar
Say I have a subform containing web-addresses (from the "web_address" field in the relevant table), and I 'd like the subform to display an html element with a link to the web-address, hence, I'd expect the following HTML-value of my Web-address column to work:

Code: Select all

<a href="http://#web_address#">#web_address#</a>
But that only literally displays "#web_adress#" in my subform column.

What do I need to do?

Re: Hashes in subforms

Posted: Mon Feb 19, 2018 4:35 pm
by agnar
Looks like hashes are not supported in the browse form (neither edit/browse forms or subforms), only the edit form.

So I tried to create a ordinary browse edit form with the following query:

Code: Select all

SELECT *, CONCAT( '<a href="http://', web_address, '">', web_address, '</a>) AS html_link FROM company
But that just ends up in an empty table, even if there are records.

Re: Hashes in subforms

Posted: Mon Feb 19, 2018 5:32 pm
by toms
Agnar,

Hash Cookies are supported in Browse Forms, make sure to enclose the cookie with a #-character.

Re: Hashes in subforms

Posted: Tue Feb 20, 2018 6:04 pm
by admin
agnar,

I'm not sure I understand your question.

Steven