Forums General discussion VLOOKUP Reply To: VLOOKUP

Silvestre Kassoka

Hi Alex,

Thanks a lot, sure his request is pretty much similar to mine and it sure was good start.The only difference is that is my case is the number of days taken is a calculated field based on start & end date.

However, in my case the following is happening,
a). The rule that calls the JS is kicking well but nothing is happening.I console.logged the res variable(log attached) it appears its not querying that Employees list.

I am also thinking its because my number of days requested <strong/> value is a calculated column ,probably when the JS kicks that field will still not a value.I am not sure.

On a side note, I tried to use the {{var:balance}} to display balance of hours but to know success.print attached.

Thank you in advance.