Use a text-formula int IF statement to display a GIF

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
So the deal is that when I select a CHECKBOX, a FORMULA-TEXT field is displayed.  This field is the conversion of a FILE ATTACHMENT field to a FORMULA-TEXT field so I can use it in an IF statement.  I am trying to have a GIF image display when the CHECKBOX is true.  This is a graphic to indicate a Priority project.

If ([TCF Priority GIF] = null,
null,
"<a href='"&URLRoot()&"up/" & Dbid () & "/a/r" & [ImageID#] & "/e6/v0' target='_blank' > " & "<img src='"&URLRoot()&"/up/" & Dbid () & "/a/r" & [ImageID#] & "/e6/v0' height='55'\"/>" & "</a>")
The above is a field in the IMAGE table that is converting the FILE ATTACHMENT to a FORMULA-TEXT field, and it works.  I have created a relationship to the PROJECT table and it just shows up as a broken link.

Thoughts?

Ways to make it work?  I want the image to be stored in the app instead of call to an image storage site -> this is because our company blocks outside links to specific sites and I want to avoid this all together.

Thanks!
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
  • why not

Posted 1 year ago

  • 0
  • 1
Photo of Michael Barrow

Michael Barrow

  • 2,206 Points 2k badge 2x thumb
I do something similar but handle it with having a Documents table in the same app, and I store my graphics choices as separate Documents records and reference their hard-coded URL's from the formula text field in my Projects table. So there's no relationship needed.
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
NICE!!!!!!!!!!!  I know for a fact I over think things.  It's always something obvious that gets me.

Cheers.