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_
|