Open related file attachment from another app
I am building a new app to replace tables and processes in a current app. In the current app there is an attachment field for a picture that I would like to link to in the new app since moving attach...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry this generic format for a clickable thumbnail which opens full screen.
var text image= "<img src=" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e12/v0' height='100' >";
var text URL= URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e12/v0' target=_blank";
"<a href=" & $URL & ">" & $Image & "</a>"
"<a href=" & $URL & ">" & $Image & "</a>"
so translating to your app.
var text image= "<img src=" & "https://foodforthepoor.quickbase.com/up/bkszu32qd& "/a/r" & [Record ID# of the original app] & "/e53/v0' height='100' >";
var text URL= "https://foodforthepoor.quickbase.com/up/bkszu32qd" & "/a/r" & [Record ID# from original app] & "/e53/v0' target=_blank";
"<a href=" & $URL & ">" & $Image & "</a>"
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Make sure when you're doing the above that either 1) Users retain access to the original application or 2) you update the file attachment settings so that users can access the file/content without logging in otherwise the link will look right but users won't be able to actually get to the content due to security reasons.
------------------------------
Chayce Duncan
------------------------------Hi Mark.....thanks for the quick response. I pasted the formula into my field and updated the Record ID field name, but the formula is showing an error in the 2nd 'var text URL'. What needs to be corrected on this? I attached a screenshot.
------------------------------
Amy Gosz
------------------------------The error is in the first variable. It's missing a double quote after the table ID.
var text image= "<img src=" & "https://foodforthepoor.quickbase.com/up/bkszu32qd" & "/a/r" & [Record ID# of the original app] & "/e53/v0' height='100' >";
------------------------------
gary
------------------------------Thank you Gary....that was it! Works perfect and a great solution for file attachments in a different app. Thank you all for your input.
------------------------------
Amy Gosz
------------------------------
