Change column content in Table View

Classic Servoy
1

I have a form with a table view and want to display one of the columns with amended data (need to perform a calculation on the foundet value on a particular coilumn then diosplay that result)

So I tried something whereby i defined a global variable and on the form I defined a field with it as the data provider.

Using the following code the form only displays the last rows values on every row instead of each row having a unique value.

Any ideas how I do this would be appreciated.

	for ( var i = 1 ; i <= foundset.getSize() ; i ++ ) {
   		var vRecord = foundset.getRecord(i);	
		do something with      vRecord.mycolumn
		globals.glbl_variable  = result of the calculation

// the global.glbl_variable is the coilumn data provider on the form
                  }
		
	}
2

A global variable is by definition global. You need to use a record variable.
A record variable can be defined by creating an unstored calculation like this:

function myRecordVariable()
{
	return;
}

But I have the feeling that you could solve your issue with a simple calculation. If you can explain what you are exactly trying to do maybe we can help.