I am trying to create a saved search to pull in th...
# administration
n
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.
r
If you are able to fetch your field in the saved search. You can create a formula html and Put in the url till id= followed by || followed by {fieldid}
n
@raghav Thank you. Can you please provide the complete criteria and results information if possible?
r
The below is your formula, replace fieldid with the internalid of the field. CASE WHEN {fieldid} IS NOT NULL THEN https://4272870=sb1.app.netsuite.com/core/media/media.nl?id= || {fieldid} ELSE NULL END If you are already filtering out where local Invoice field is not empty then you can use just this https://4272870=sb1.app.netsuite.com/core/media/media.nl?id= || {fieldid}
🙏 1
n
Thank you very much. Let me try this and let you know the results.