Lookup field for child table report link
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 servi...
Forum Discussion
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:
------------------------------
Eric Mohlman
------------------------------
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
------------------------------
- MarkShnier__You
Qrew Legend
Eric can you explain what this part does? Is it to defeat caching when the image file is changed?
If([file attachment]<>"","<img src=\"" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e28/v0/" & URLEncode([file attachment]) & "\" height=\"50\"></img>")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Mark,
I put that in to handle any special characters in a file attachment name
------------------------------
Eric Mohlman
------------------------------- Eric,
Thanks - that is something I can definitely use. But I'm not sure how to adapt it to my need? In my case, I'm not trying to pass the image of the file to another table, but rather I am trying to pass the report link (containing all image files) from the parent table, down to another table.
The use case being - once my asset is associated with a service order, there is a report link on that service order of all the assets related to that service order.
In that report link, I was hoping I could show the asset name, and then a report link to the asset photos....
So I need to get the asset photo report link from the asset (parent) table, then down to the assignments table (the link for the many to many).
------------------------------
Mike Tamoush
------------------------------
