I have a file attachment and I'm looking to make a button for the user to preview the file attachment. I found an old thread about this suggesting the following, however when I click that I get a url cannot be found web page. Also, it opens in the same tab as quickbase, and I am hoping to open in a new tab. Can anyone help? Thanks!if ([Document]>"", "<a href=\"" &URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#]& "/e999\"target=_blank\">" & [Document]& "</a>","")change the 999 in e999 to be the field id of the Document field------------------------------Mike Tamoush------------------------------

When using Juiced Technologies' S3 upload; you can use a modal-window to "view" the file without downloading it. Despite trying, we have not found a way to do this with a native file - if you (or someone else) by some chance figure it out; please share. It would make a massive impact for users to be able to display a stored native file attachment in a pop-up window instead of having to download them.------------------------------Laura Thacker (IDS)laura@intelligentdbs.com(626) 771 0454------------------------------

Yes, he has an example of how to setup some funky code as a formula text field and then using that field as both sides of a report link field..If([Document Attachment]="","No File",Ends(ToText([Document Attachment]),".jpg"),"",Ends(ToText([Document Attachment]),".png"),"",Ends(ToText([Document Attachment]),".gif"),"","<iframe src=\"https://docs.google.com/gview?url="&URLRoot()&"up/" & Dbid () & "/a/r" & [Record ID#] & "/e6/v0 "&" &embedded=true\" width=\"600\" height=\"600\" frameborder=\"0\" target=\"_blank\"></iframe>")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Reach out to Ryan Stanford, he was able to do it. Check out the last entry of this thread:video in pop up window------------------------------Adam Keever------------------------------

try thisIF(ToText([Document]) <>"", "<a target='_blank' href=" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e999/v0" & ">" & Totext([Document]) & "</a>")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

.. field type would be Formula Rich Text------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

URL Button to Preview File | Qrew Discussions

AdamKeever1
Qrew Commander
5 years ago
Reach out to Ryan Stanford, he was able to do it. Check out the last entry of this thread:
video in pop up window

------------------------------
Adam Keever
------------------------------
- BabiPanjikar
  Qrew Assistant Captain
  5 years ago
  @Adam keever, thanks for resharing the post. This is useful. I had the similar requirement recently to open the file itself when clicked. However, due to native, it only got download instead. I was using excel/word/ppt and pdf files.
  
  ------------------------------
  Babi Panjikar
  ------------------------------
  - SrinathM_R2
    Qrew Member
    4 years ago
    I guess It's a bit late but I am using this option to preview the files and it works well for me.
    Field = Formula URL
    
    var text url = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e6/v0";
    var text doctype = Right(Right(ToText([File]), "/"), ".");
    If ($doctype = "pdf" or $doctype = "doc" or $doctype = "PDF" or $doctype = "DOC" or $doctype = "xls" or $doctype = "xlsx" or $doctype = "pptx" or $doctype = "docx", "https://docs.google.com/gview?url="&$url&"&embedded/=true",URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e6/v0")
    
    Places where you have e6 insert the field I.D instead of 6 and if you come across any other document type that you are using then just add it's extension to the doc type and it should be good.
    
    ------------------------------
    Srinath MR
    ------------------------------
MarkShnier__You
Qrew Legend
5 years ago
try this

IF(ToText([Document]) <>"",
"<a target='_blank' href=" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e999/v0" & ">" & Totext([Document]) & "</a>")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  .. field type would be Formula Rich Text
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  markshnier2@gmail.com
  ------------------------------
  - MichaelTamoush
    Qrew Captain
    5 years ago
    That works but just downloads it. I suspect it would be a preview if I changed my chrome settings, but Im trying to come up with something where it just works without changing the settings. Also would be great if it was a url formula so i could make it a button.
    
    ------------------------------
    Mike Tamoush
    ------------------------------

Forum Discussion

URL Button to Preview File