I have a quick and easy process for users to upload supplier documents:
When these files save to Laserfiche, they're saved in a subfolder using the same name as the transmittal:
It saves with the PDF extension. How can I avoid that?
I have a quick and easy process for users to upload supplier documents:
When these files save to Laserfiche, they're saved in a subfolder using the same name as the transmittal:
It saves with the PDF extension. How can I avoid that?
I did it! I created two hidden fields:
1. "transCopy" that actually grabs the name of the uploaded transmittal name and
2. "subfolder" which contains a formula that removes the .pdf
As recommended by Karina, I changed my formula to:
=LEFT(Field, SUB(LEN(Field), 4))
My end result:
Hi Gloria,
What happens if there are extra periods in the name of the file? Below is a slightly different approach that trims the last 4 characters (the period and the 3 characters of the extension)
=LEFT(Field, SUB(LEN(Field), 4))
Thank you! Very helpful. Used that instead.