I am trying to create a saved search to pull in the file's URL that I uploaded to an invoice transaction. I created a custom Document field called Local Invoice and uploaded a pdf to that. Now, I want to pull the PDF url into an invoice saved search. Thread in Slack Conversation

Have you tried a formula using the {fieldid.url} I seem to recall that works but have no example at hand.

I have tried all the possibilities but it is constantly saying invalid expression. Here is the formula I am using. Please let me know what changes are needed to get what i am looking, if possible. CASE WHEN {custbody5} IS NOT NULL THEN 'https://4272870=sb1.app.netsuite.com/core/media/media.nl?id= ||ELSE ''END