Attaching URL in Comments Save

[Former Member]

Hi Everyone,

We have a scenario wherein we will have to save the URL as a comment. If we save the URL Now, its saved as a normal text. Can anyone help in giving the solution for this?

Thanks,

Thanuja Sekar

[former_member186338]

In my sample it's working as URL:

Inside D7 in =EPMSaveComment(...) it will be text, but in F7 - it will be URL

If I clear F7 and refresh - URL will come back!

Vadim

[former_member186338]

P.S. And for you can always present text as clickable URL with:

=HYPERLINK(D7;"Test Name")

Vadim

[former_member186338]

P.P.S. Yes, you are right - in F7 it looks like URL, but not clickable

HYPERLINK will do the job!

[Former Member]

Hi Vadim,

In D7, EPMSaveComment is used. And what is there in F7? Is it just the link that we want to save?

[Former Member]

Hi Vadim,

We need to use three different cells for this. Please find the screenshots below.

First Screenshot :

Cell wherein we will enter the link (K72)

Second screenshot :

Cell to use Save comment (L72)

Third screenshot :

Cell to show the saved comment as Hyperlink (M72)

This is the way I have given. Is there any option to reduce the number of cells. I mean in one go, can we save and show it as a hyperlink.

Thanks,

Thanuja Sekar

[former_member186338]

Yes, I am talking about 3 cells. You can hide the cell with EPMSaveComment...

Vadim

[Former Member]

Yes That's what I have done.

Thanks.

[former_member186338]

Then - close the discussion.

Currently there is no way to reduce number of cells.  The issue is that on refresh the URL string is inserted in F7 as text. And you have to simulate editing of this field to convert it to the clickable URL.