How to reference the "Name" Field in a document library using calculated columns

Question

_{Saturday, May 14, 2011 4:14 AM}

Hi,

I want to create a column that could contain the value of the "Name" column. I tried to use a calculated column but in the "Insert Column" box, I couldn't find a column called Name.

How can I reference "Name" column in a calculated column?

Thanks!

All replies (5)

_{Wednesday, May 18, 2011 11:46 AM ✅Answered}

Hi bonniepan,

Did the workflow start successful, and can you find the workflow status, did it set to Completed?
Do you use a System Account to do the test? System Account can't sync start the workflow, you can manually to start the workflow or use another account and try again. It should work.

Best regards,
Emir

_{Saturday, May 14, 2011 5:45 AM}

It seems to  me that it is not allowed to reference the Name field in a calculated column. But alternatively Name field is accessible from sharepoint designer workflow(which will be triggered during the item creation). So we can create a custom text field (instead of a calculated column, if it serves your purpose) and the value for this filed can be calculated(updated) using set current item action  by the Name field.

Thanks,

Gopal

_{Saturday, May 14, 2011 12:52 PM}

Hey Gopal, 

Thanks for your workaround. I tried to do what you said. I never used workflow before. Could you give me more details?

For example, I have a doc lib Test, I want URL column is updated or set to the value of Name column when a new doc is added.

I created a new list work flow, associate to the Test List.

I created two steps.

Step 1: Update item in Current Item.

Step 2: Set URL to Current Item: Name

Then, I configure the Start Options to start automatically when an item is create or changed.

After I have saved the workflow, I added a doc to the "Test", the URL field is not updated as expected. 

Could you please take a look at the procedures that I have done? Thanks.

_{Saturday, May 14, 2011 8:13 PM}

Bonniepan, the Name field is not a URL.  If you want to populate a hyperlink field with a full URL, then you need to give it a full URL. You're only giving it the Name value, which is something like "Filaneme.Doc."  You also didn't tell us what happened.  YOu just said "the URL field is not updated as expected."  Well, come on, what did it do?  We can't read minds - you need to tell us the actual result in order for us to fix it.  My guess is it just populated with the Name field's value just as you told it to do.

You need to construct the full URL by combining the URL of the doc lib with the Name field...or just use Encoded Absolute URL, which is an available piece of metadata.  Also, don't use UPdate List Item - use Set Field in Current Item.  Lastly, why are you creating another link to the same doc in a separate field?  Why have two fields both pointing to the same doc when the OOTB one already has the context menu and full fidelity while your URL field has no such functionality?  What are you trying to accomplish?

SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force

_{Sunday, May 15, 2011 3:33 AM}

Hey Clayton,

My URL column in my example is just a single line of text type column, not the hyperlink type column. Sorry for my confusing naming. It can be called anything, for example FileNameCopy. 

when I say "after I have saved the workflow, I added a doc to the "Test", the URL field is not updated as expected", I meant there was no value populated on that "URL"(single line of text) column.