Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Using the file namd in a calculated column

  Asked By: Ernie    Date: Aug 12    Category: Sharepoint    Views: 17823

This seems so obvious, but how does one access the 'file name' (called name
on all items) in a calculated column?

Basically, I want to obtain the first few characters of the file name in a
calculated column.

I can see and access the 'title' column, but not the name column.

What am I missing??



4 Answers Found

Answer #1    Answered By: Ted Gilmore     Answered On: Aug 12

I have tried at length (hours really) to get access  to the Name field in
a Document Library but alas everything I've tried has failed. I don't
know why the don't want us to use the Name field in calculations. Maybe
because it is used to generate the dropdown menu list?

Answer #2    Answered By: Monte Cooley     Answered On: Aug 12

The name is really the link to the document I think. The ServerURL. I am
wondering if there is a function to decode it from the ID. I'll report

Answer #3    Answered By: Guadalupe Bullock     Answered On: Aug 12

Well here is what I have found regarding using the 'filename' in calculated
columns. If anyone can correct my thinking, please do. I personally hate
this issue, it is a very limiting thing.

It seems to me that the construction of calculated  columns in a view works
only on 'columns' in the list (i.e. like "title" and not other read only
columns or calculated columns etc.

I figured out how to create new columns based on the schema and onet files,
but it seemed that no matter what I could do, unless the column  was based on
a "column" associated with the list, I couldnt use it.

Answer #4    Answered By: Nathanial Mcclure     Answered On: Aug 12

Yeah, that’s pretty much it. The “filename” column  (which depending on the list is the Name column if you look at the InternalName property) isn’t something that seems to be available in any way, shape, or form (programatically or otherwise). The Name is the best bet, but it’s not avaialble for the type of selection or calculation you want as only the title  is exposed.

With calculated  columns, there are very few columns you can pick from for your calculation. A funny thing is that you can pick the ID even though it’s not listed. Maybe because it’s universal but you would think other columns would be available but they’re not.

SharePoint isn’t a silver bullet that can solve any problem so with any problem you’re trying to find a solution for, it might not be the right technology.

Didn't find what you were looking for? Find more on Using the file namd in a calculated column Or get search suggestion and latest updates.