Show filter not working on text for url type?

[Tom_automated]

I’m trying to hide a GSheet url if GSheetID does not exist. I’ve got:

where the formula is

and the show filter is

The url icon is successfully hidden when GSheetID does not exist but the text still shows in detail view:

What am I doing wrong?

[OptimiX_XcrY]

Don’t know if this helps

The text formula can generate a blank value if gsheetid is blank, else “hyperlink etc”

The showif can just be isnotblank([gsheetid])

Can you post more screenshots ?

[Tom_automated]

What other screen shots did you need? I’ve even tried using LEN([GSheetID]) = 10 in the show filter since I know the GSheetID if it exists will be 10 characters long.

[Steve]

What is a "show filter?

[Tom_automated]

In the data columns:

[Steve]

[Tom_automated]

That got it.

[OptimiX_XcrY]

Is there at least one column always visible and never blank in your table ? Maybe detail view can’t be blank. I’d suggest a screenshot of a detail view example, and of the table columns in the editor

[Tom_automated]

Yes, there’s always something visible in the table.

[OptimiX_XcrY]

Also, as app formula (in case we can’t manage to hide it) , I’d suggest

If(isnotblank([gsheetid]); hyperlink(…);"")

for esthetics

[Steve]

OptimiX_XcrY:

I’d suggest

If(isnotblank([gsheetid]); hyperlink(…);"")

Or just:

IFS(ISNOTBLANK([gsheetid]), HYPERLINK(…))