Accessing record from inside a table field?

Thank you.

The table has 4 columns, Set, Reps, Weight and Target Weight and the Id of the table is fld-f59e078819e24d2aa1492d36d8fe268c.

The situation is the following:

1. The form contains a field F that is not a table and a field that is the table T.

2. The table T contains a column T_s of type script.

3. For any given record I want to have access to the value of field F inside the script that pertains to T_s.

If I run the following code inside T_s’ script (fld-f59e078819e24d2aa1492d36d8fe268c is the Id of the table)

var table_field_id = 'fld-f59e078819e24d2aa1492d36d8fe268c';

var testrecords = record.getFieldValue(table_field_id);
	
console.log(testrecords.length);
		
var testvalues = record.values;
		
console.log(testvalues.length);	

I get the output:

11.04.22, 18:44:59 / Sets Old / Target Weight
0
undefined

I’am new to Tap Forms 5. Maybe missing some fundamental stuff here?

Cheers

Sure. Thank you.

Dear Daniel,

the idea to move the intensity calculation to the main record was really helpful.
Thank you for your kind help. I greatly appreciate it.

Cheers.

Thank you Brendan. In case anybody is interested to alter the column of a table field (‘intensity’ in the example) in a form according to some other field in the form:

Solution according to Daniel Leu:

Define a (hidden) script field in the form:

function Intensity_Calculation() {
	var onerm = record.getFieldValue('fld-22846df6ecc24d0d8c4cf9dfbb7ea75a');
	var table = record.getFieldValue('fld-f59e078819e24d2aa1492d36d8fe268c');
	
	for (var index = 0, count = table.length; index < count; index++){
		var intensity = table[index].getFieldValue(
               'fld-d12f0981ef2c426988233a09cf0d9bb0')/onerm;

		table[index].setFieldValue('fld-fb5ff2183ad24d62a4a11ced1922b6ea', intensity);
	}
}

Intensity_Calculation();

Solution according to Brendan via a script inside the table field:

function Intensity_2() {

	// Getting the field value from the field 'Weight' in the table, 
        // is used in the following calculation and triggers
	// the script to execute when the field 'Weight' is modified.
	
        var weight = record.getFieldValue('fld-d12f0981ef2c426988233a09cf0d9bb0');
	
	// The id of the field 'OneRm' of the parent form.
	var parent_one_rm_id = 'fld-22846df6ecc24d0d8c4cf9dfbb7ea75a';
	
	// Getting the value of field 'OneRm'	
	var parent_one_rm_id = record.parentRecord.getFieldValue(parent_one_rm_id);
		console.log(parent_one_rm_id);
       
       	// A simple calculation		
	var intensity_2 = weight/parent_one_rm_id;	

	return intensity_2;

}

Intensity_2();

See also the attached form template.

Cheers.

Thank you!