Hi there!
I have this javascript hotspot action formula:
onclick=‘javascript:window.location.href="ItemSortOrderingDisplayListsForm?OpenForm&count=5000&RestrictToCategory=" + @URLEncode(“Domino”;List[i]) + ""’
It works well except when the RestrictToCategory parameter contains an apostrophe. Nothing happens at all when the parameter contains an apostrophe.
Any ideas?
Gérald
Subject: OpenForm and…
Shouldn’t it say “?openview”? Have you tried using an Action Hotspot containing a @URLOpen() formula?
Subject: URL parameters containing an apostrophe are ignored.
@urlEncode converts these characters: @#$%^&+{},./<>?|`"
to these Hex values:
%40, %23, %24, %25, %5E, %26, %2B, %7B, %7D, %5B, %5D, %2C., %2F, %3C, %3E, %3F, %7C, %60, %22
and doesn’t convert ~!*()_’
So the get these other characters to convert, you have to manually turn them into Hex code this way AFTER you do the @urlEncode:
@ReplaceSubstring(@AttachmentNames; @Char(34):@Char(39);“%22”:“%27”)
To get the ascii for a character hold down the Alt + 1-2-3_digit number will give you the ascii character.
Here’s the final code:
@ReplaceSubstring(@URLEncode(“Domino”;List[i]) ;@Char(34):@Char(39);“%22”:“%27”))
Sean