Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
6 years ago

File Name Work Around

I have a snippet of code below that names a file that is being created. It names the file "Approval_[file]'.  (file is the field where I have a file uploaded. The resulting file is a merged file)

& " fn=Approval_" & [File]

The problem is, since my file is a .pdf, the resulting name is "Approval_filename.pdf.pdf"

There is an extra .pdf with the current code. Can't figure out how to solve that problem.


------------------------------
Mike Tamoush
------------------------------
  • This looks like a code snippet from a  Juiced EF+ button.
    Perhaps try this

    & " fn=Approval_" &  notRight([File],".")

    That would trim off the .pdf from the value in [File]


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------