Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
I'm trying to better understand your question. Are you saying that you have a formula which works when you click the link, but the thumbnail is not working?
- JoshCollins7 years agoQrew Assistant CaptainSorry if my question was unclear. I have 2 different fields:
1) I have a basic URL field in App 1 where I manually add a URL for an image. When I save then click that URL, the link works fine (in other words, a new tab opens and I see the image that I linked.) The link I'm using happens to be out of a different Quick Base application where I store all the images I want to use, we'll call that "Images App."
2) I have a Formula Rich Text field in App 1 where I use the code you provided to display a thumbnail image. The reference field in the formula (E35) is the URL field from #1 above.
I'm guessing that since the field in #1 above is referencing a URL, not a file attachment field, the formula in #2 field isn't pulling an image.
My question is: Is there a way to pull the image that the URL field is reference? If not, then is the only solution to upload the image via a file attachment field in App 1 rather than my dedicated "Images App"?
Thanks! - QuickBaseCoachD7 years agoQrew CaptainYou do not need to double load your images. But you will need to replace the dbid() with the table "code" in the other app. and you will need to replace Record ID with the record ID of the record that holds the image in the other app.
But before I go into the suggestion of the code, why not just make a relationship back to your images table and pull the image formula down as a lookup field? - JoshCollins7 years agoQrew Assistant CaptainRe the relationship: I'm sure that will work. I'm not super adept at relationships from other applications though. I'll give it a shot and probably ask some questions in the process. _
- QuickBaseCoachD7 years agoQrew CaptainThe point is that you will need to specify the Record ID of the images app, in the formula, so it knows which image to pull, so may as well select that off a relationship.