How do I find a field's internal fieldname?



Question

Many KWizCom products require that you use a field's internal field name rather than the name of the field that is displayed. In the case that the name a SharePoint list's field name has been changed, the internal field name will still remain the same.

Where can you find a field's internal field name?

Answer

To find a field's internal name, go to the list > then go to the list settings > and then the field settings. In the the URL bar at the end of the URL, you should see "Field=" and what follows will be the field's internal name.

 For example, if you see the following in the URL bar:

https://kwiz-dean.cloudapp.net:2013/charts/_layouts/15/FldEdit.aspx?List=%7B2E3CD68B%2D408F%2D4A3B%2DA2C7%2D5E652DC60C70%7D&Field=Sales

The internal field name would be "Sales"

In the case that there are special characters in the internal field name such as a space, the internal field name will encode the special characters. For example, if the URL shows:

https://kwiz-dean.cloudapp.net:2013/charts/_layouts/15/FldEdit.aspx?List=%7B2E3CD68B%2D408F%2D4A3B%2DA2C7%2D5E652DC60C70%7D&Field=Inspection%5Fx0020%5FType

The internal field name IS NOT going to be "Inspection%5fx0020%5fType" nor will it be "Inspection Type".

In this case the space has been encoded as "_x0020_". Because of the underscores, these have been changed in the URL to "%5F" as well. As such, the actual internal field name in the above example would be: Inspection_x0020_Type

As such, to get your internal field name, convert all instances of %5F to an underscore and copy and paste everything after the "Field=" to get the internal name.

If you have other special characters, please note that they will be converted to based on the chart below: 

Character

Internal Hex Code

~

_x007e_

!

_x0021_

@

_x0040_

#

_x0023_

$

_x0024_

%

_x0025_

^

_x005e_

&

_x0026_

*

_x002a_

(

_x0028_

)

_x0029_

_

_

+

_x002b_

_x002d_

=

_x003d_

{

_x007b_

}

_x007d_

:

_x003a_

_x0022_

|

_x007c_

;

_x003b_

_x0027_

\

_x005c_

<

_x003c_

>

_x003e_

?

_x003f_

,

_x002c_

.

_x002e_

/

_x002f_

`

_x0060_

_x0020_