Reply To: VLOOKUP

Forums General discussion VLOOKUP Reply To: VLOOKUP

#29546
Silvestre Kassoka
Participant

Hi Alex,

Thanks for the heads up.well. i spend the whole day cracking on this but cannot seem to get the hang of it.

From the logs, i can tell that the query is working fine which is is the first part of the code.

(function () {
var res = spjs.utility.queryItems({
“listName”: “Total de Ferias”,
“query”: “<Where><Eq><FieldRef Name=’Person’ LookupId=’TRUE’ /><Value Type=’Integer’>” + _spPageContextInfo.userId + “</Value></Eq></Where>”,
“viewFields”: [“ID”, “Ferias_x0020_para_x0020_Gozar”]

However , the portion below is getting an undefined.
if (res.count > 0) {
var item = res.items[0];
balance = Number(item.Ferias_x0020_para_x0020_Gozar);
}
console.log(item);

The other log errors i cannot interpret i just attached them.