Field Event /Variable Trigger not working to open URL

[saumyashah90]

I have straight table.

Having Image Name and Image Location as columns.

Now when I click on any Image Name and event should trigger and open and URL.

Similarly on trying same with variables, I set variable on selection on Image Name.

and triggered an event in change of variable value to open the URL, but again its not opening

I have attached QVW and excel file with it

[saumyashah90]

anyone??

[jagan]

Hi Saumya,

Try like this

Create a variable

vSelectedURL : =Only([Image Location])

Use below Macro in Document Properties -> Triggers-> Field Event Triggers-> On Select:

Sub Browse() 

  set v = ActiveDocument.GetVariable("vSelectedURL")

    Set ie = CreateObject("Internetexplorer.Application")

    ie.Visible = True

    ie.Navigate v.GetContent.String

End Sub

Regards,

Jagan.

[jagan]

HI,

Please find  attached file for solution.

Regards,

Jagan.

[saumyashah90]

Hi Jagan,

This looks good

But on clicking clear all also it opens internet explorer.

[jagan]

Hi Saumya,

Try like this, Put one condition in macro like

If(GetSelectedCount(ImageName) = 1, MacroName)

Regards,

Jagan.