Skip to main content
Question

Lookup field for child table report link

  • December 13, 2019
  • 0 replies
  • 91 views
Forum|alt.badge.img+14
I have a many to many relationship between Assets and Service Orders. The third 'linking' table I called SO Asset Assignments.

On my assets table, there is a child table for photos. 

On my service order table, when I am displaying the report link to the SO assignments, I want to be able to have one column be the Photos report link.

However, I cannot send that photo report link to the Service Order Asset Assignments as a lookup field, therefore it's not available as a column option to add. Is there a work around or something I am doing wrong?

------------------------------
Mike Tamoush
------------------------------

  • EricMohlman
  • Quickbase Staff
  • December 16, 2019
I taught how to do that at our Empower conference earlier this year if you'd prefer to watch a video:https://university.quickbase.com/empower2019-course/342287.

If instead you're like me and prefer text information, the details here: https://help.quickbase.com/api-guide/filemanagement.html show how file attachments can be accessed. That then allows us to create a formula rich text field, with a formula like this:

If([Image]<>"","<img src=\"" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e8/v0/" & URLEncode([Image]) & "\" height=\"50\"></img>")

Your version will most likely have a different number instead of 8 and your file attachment field will have a different label, but beyond that you can copy/paste this example.



------------------------------
Eric Mohlman
------------------------------
    Terms & ConditionsAccessibility statement