Hyperlink Query

system · June 27, 2011, 8:57am

I have a hyperlink in a column that links to external information where appropriate.

The ‘where appropriate’ is key here. When i have data to input into the external site another colomn has data, where i dont need the link the other colomn is blank.

In the blank rows i dont want the link to be displayed, i had this formula to produce the disired result but it was not part of the hyperlink.

=If(IsNull([incident FMS]); “”;[FMS LINK])

simply put, how do i turn off the hyperlink where it is not required (where there is no data for the link).

Thanks,

Dan

[Moderator Note: Moved from General Discussion to WebIntelligence XI- Marek Chladny]

dantheram (BOB member since 2011-06-27)

system · June 27, 2011, 2:05pm

Hi,

Yes, you can use if then else to have different hyperlink depending on different conditions.

Check this out.

M H Mohammed (BOB member since 2010-06-16)

system · June 27, 2011, 2:34pm

http://ukrsrvsdc11101/F2000_V3_OBSERVER/WebPages/readonlyfault.aspx?ID=([Incident FMS])

above is my current hyper link but i’m a novice user of the system and, as such, do not fully understand how to incorporate the ‘IF’ syntax.

My variable is the ‘incident FMS’ which is sometimes a null value, in which case i want a blank response from the hyperlink.

Can someone help here?

Many thanks,

Dan

dantheram (BOB member since 2011-06-27)

system · June 29, 2011, 8:15am

Bump

dantheram (BOB member since 2011-06-27)

system · July 9, 2011, 8:33pm

Hi Dan,

=If(IsNull([incident FMS]); "";[FMS LINK])

So where you have the ‘else’ section you would need to define the OpenDoc code. The easiest way to create this code is to open the report in view mode, right click > hyperlink > new. You can choose to link to a webpage. Go through the options and apply.

Now open the formula bar and add every up to ; before the ‘else’ section and place a closed bracket ) at the very end.

FYI, as far as I’m aware this wizard method is not available in the edit mode.

Let me know how it goes

Ally

ally3009 (BOB member since 2010-08-10)