Here is my scenario. I have a notes view put on to an xpage, in that view I have a user “ID”, this is column A. The only column in the notes view.
Column B, added on the xpage, uses javascript to call java to retrieve data from SQL, based on the ID in column A. My results will look like this:
UserName^MovingExpenses^MovingBudet
What I want to do is access that data in Column B and create Column C (Moving Exp) and Column D (Moving Budget).
If I enter this formula in column C, I get an error 500 on the web:
var exp=“na”;
exp = detailrow.getColumnValue(“viewColumn2”);
var tmpVal = exp.split(“^”);
tmpVal[2];
Now if I change ‘getColumnValue’ to the lookup in Column B and do the split it all works right, but I want to do one lookup to SQL and parse that data per row, then do 2 lookups.
So my question is it possible to do grab the view data of a computed field then parse it to other columns? Or heck am I doing this the wrong way? Please feel free to offer any suggestions.
TYIA