ArchiveUser
8 years agoQrew Captain
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.
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!
If ([TCF Priority GIF] = null,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.
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>")
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!