Reply To: VLOOKUP

Home 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.