General

Re: Substring attachment URL

Evanz — Fri, 23 Apr 2021 00:24:16 GMT

Thank you so much for your great suggestion, Hilary. I appreciated it. You're the best. :-)

Have a great evening!

Best Regards,

Re: Substring attachment URL

Hilary Stoupa — Thu, 22 Apr 2021 20:03:38 GMT

This isn't possible, for the same reason as your other question, except in this case, code isn't an option because we can't add code to list forms. FormsViewer can do this - both for list and library forms, so if this is a feature you need, you may want to check it out. :)

Re: Substring attachment URL

Evanz — Thu, 22 Apr 2021 19:51:37 GMT

Thank you for your quick response, Hilary. The function works now without errors. However, when I use the function "Fx" for a text field, it only shows the file name of the attachment after submission. But I would like to the file name shows right away on the text field after a file attached, is it possible? if yes, how do I make it work? Any suggestion is greatly appreciated. Thanks again, :)

Re: Substring attachment URL

Hilary Stoupa — Thu, 22 Apr 2021 17:44:48 GMT

Prior to "https" you need to select your field that has the attachment URL and add a comma. You'll see in my sample I had placeholder text for that.

Re: Substring attachment URL

Evanz — Thu, 22 Apr 2021 17:38:21 GMT

Hi Hilary,

I just tried to do in the following steps:

Click on Text Box properties and click on "Fx" function > insert function: substring-after(substring-after("Link"), "/")

Re: Substring attachment URL

Evanz — Wed, 21 Apr 2021 00:13:15 GMT

Thank you for your quick response. Let me try it out. Thanks, :)

By the way, is it possible to get the same solution for the InfoPath document library as it does not appear the attachment URL like the list? How can I make it work? Any suggestion is greatly appreciated.

Re: Substring attachment URL

Hilary Stoupa — Wed, 21 Apr 2021 00:02:52 GMT

I think you could use substring-after(substring-after(URL Field Here, "https://eddnet/sites/TestSite/Lists/TestRequiredFields/Attachments/"), "/")

Re: Substring attachment URL

Evanz — Tue, 20 Apr 2021 23:35:54 GMT

Hi Hilary,

Sorry, other post is slightly different because I realized that the InfoPath form for other post is using the Document Library, which somehow it does not appear the attachment URL as same as the list. Therefore, I was only able to display the attachment URL on the text field for the InfoPath SharePoint list, not the document library and I would like to use a substring for URL (Ex: https://eddnet/sites/TestSite/Lists/TestRequiredFields/Attachments/7/Test Doc5.docx) to get the only file name as Test Doc5.docx. is it possible? thanks so much for your help!

Re: Substring attachment URL

Hilary Stoupa — Tue, 20 Apr 2021 21:41:26 GMT

I'm guessing this is related to your other post - what does the URL look like? This must be a SharePoint list form, right? So the URL will have the item's list ID prior to the name? What's a sample URL?

Substring attachment URL

Evanz — Tue, 20 Apr 2021 21:22:50 GMT

Hi, My InfoPath SharePoint list has a file attachment and I am able to display the attachment URL in a separate text field after a file attached. I wonder if there is a way to use a concat (substring-before(My URL), substring-after (My URL)) to get a file name of the attachment to be displayed in the text field, is it possible? Any suggestion is greatly appreciated!

Thank you so much for your help!