How do I show an image from one table in another table?

  • 41
  • 1
  • Question
  • Updated 2 months ago
  • Answered
I have a relationship and it shares multiple things but I need the image from one to appear in the other table.
Photo of Nate McKinney

Nate McKinney

  • 304 Points 250 badge 2x thumb

Posted 6 months ago

  • 41
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
No problem

Make a formula rich text field lie this on the table with the image.

"<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" 
& [Record ID#] & "/e324/v0 height=100>"

and then look it up to the child.  Replace the 324 with the field ID of  the file attachment image.

Set either the height or the width to your liking.  (change height to width to control the width.  If you try to set both the image will get skewed.
(Edited)
Photo of Nate McKinney

Nate McKinney

  • 304 Points 250 badge 2x thumb
how do i look it up to the child
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
Build the formula on the Parent Table which holds the image. Then just make a lookup field in your relationship.
Hi. I followed more than one time all your guidance but still not showing the image in the child table.  this is the outcome with I lookup in the child table

thanks in advance

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
Does the link work on the original table before the lookup?
  
Did you set the correct field ID which holds the file attachment? 

Can you post your formula.
formula in original table: "<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" 
& [TNSID] & "/e200/v0>" 
see the picture bellow how both fiels has been set on the original table


in the original table, I added the field (Display picture) into the form but is not working as well.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,842 Points 50k badge 2x thumb
What is the field called which is the [Record ID#] of the Table.  Is it still called [Record ID#] or did you rename it?

I was expecting the formula to read as 

"<img src=" & URLRoot() & "up/" & Dbid () & "/a/r" 
& [Record ID#] & "/e200/v0>" 
Yes, I rename it. there is one field in the original table name TNSID but that is not the Key field. I changed for the Key field and worked perfectly. you help me to find the error thank you so much