Missing Hyperlink in some rows

[JTK21]

Hi everyone,

I have a problem with the output of my hyperlinks. In some cases the hyperlink is not stored. The data comes mainly from two tables. Id, hyperlink from table A and employee from table B. The case where the link does not work is when there is no employee for the id and therefore a NULL value is in it. However, I wonder why it should affect the hyperlink, because it is obviously there and is only composed of a URL + Id.

Can anyone help me with this?

[JTK21]

Hi @NikhilChenna ,

of course, so here is the definition of my Hyperlink : 

I have added this as a web URL under the "Conditional formatting" field.

Here is another example:

and the Data Model:

please let me know if you need more information and if so what kind of Data

Best Regards,
J

[Sweet-T]

Hey J, did you get closure on this? 

I'm guessing it had something to do with the fact that the rows without hyperlinks also didn't have Emloyees listed? Maybe because they didn't have rows in the related table, the conditional formatting wouldn't populate? 

I am also having this issue. 

[NikhilChenna]

Hi @JTK21 ,

Can you share some sample data with thr links so that we can understand more clearly .

Regards,

Nikhil Chenna