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
Qrew LegendEric 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
------------------------------
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
------------------------------- Mike,
Thanks for clarifying. I apologize if I misunderstood the original request.
For report link fields, they simply need a "local" field and the "target" field on the table you're matching against. Based on your updated description, you should have a field on the Assets table labeled something like "Related Service Order". If you create a report link field on the Asset table, the in its field settings choose the Related Service Order as the local field, and the Assets: Related Service Order for the foreign field, it should show all Assets part of that same Service Order.
If that's not the actual setup you want to accomplish, keep in mind that the local field matches the target field as a general rule. This means you can display grandchild records on a table, or something with no relationship at all (i.e. I have a Widgets table with a "color" field, and as I'm looking at a product I can show all widgets with that same color).
------------------------------
Eric Mohlman
------------------------------
