Is there an option to use parameters as path / URL in calculated column?

Question

_{Thursday, May 8, 2014 12:19 PM}

Is there an option to use parameters as path  / URL  in calculated column?

keren tsur

All replies (6)

_{Thursday, May 8, 2014 12:37 PM}

Hi

can you be more explicit please?

Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

_{Thursday, May 8, 2014 12:41 PM}

We have a library with folders in it.

For example: ProjectDocs/Projects/[Project Name]/[Project Stgae]/[Doc Name]

i want to get the Project Name from the URL and write it to a column

same for the Project Stage.

keren tsur

_{Thursday, May 8, 2014 12:51 PM}

Hi

One of the column in a Library/List which contain the path is [FileRef]

Try using it, and customize it as you need

Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

_{Thursday, May 8, 2014 8:11 PM}

Hi

I've created a real example for you, using a workflow which will fill the column, when an item is added to the library

To see my example please visit this link

Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

_{Friday, May 9, 2014 5:23 AM}

Hi keren,

In addition to workflow approach, you can also check if Document Set content type can be sued to achieve your goal, if you want to share the Folder/Document Set one column value to child items.

See the following article for more about the Document Set and column sharing.

http://blog.collabware.com/2013/12/02/the-advantages-of-document-sets-and-metadata-sharing/

Thanks

Daniel Yang
TechNet Community Support

_{Sunday, May 18, 2014 11:44 AM}

I used that column sharing in document set a lot :)

But document set is predefined, and here we have lots of folders that their name represent a value which is the value i need as managed property. If there any way to get the folder name as property it would have done the work

keren tsur