File Name Work Around

Question

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
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community