Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

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

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!
  • 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.
  • NICE!!!!!!!!!!!  I know for a fact I over think things.  It's always something obvious that gets me.

    Cheers.