Importing values from all related records

[Eddy]

Hi Folks!

I have a (hopefully) small issue …

In order to categories records, I use a many-to-many relationship. This allows me to change the names of the categories later, because the category name is the value of the first field in the related record. And in the related record I can see easily a list of all records, with are under a specific category. So, this is the advantage compared to a picklist.

But now I need to read out the category-names, so that I can use them in the mother record. Concrete, I want to script, so that I have a text field, with just list all the category names a specific record belongs to.

So, call my stupid, I find no way. Of course, I know how to import a field value from a related record. But how can I get a list of all the field values in the first field of all the records wich are related?

Thanks in advance, all the best, stay healthy!

Eddy

[Daniel Leu]

For my example, I have a parent form and a child form and they are linked. The link field has the id fld-aaa.

function Childs() {
	// get all child records
	var childs = record.getFieldValue('fld-aaa');

	// define id of name field of the child form
	let childNameId = 'fld-xxx';

	// clean results formatted as an array
	let childNames = [];

	// loop over all childs
	for (child of childs){
		// get name of child and add to result array
		childNames.push(child.getFieldValue(childNameId));
	}
	
	// return child names as a comma separated string.
	return childNames.join(', ');
}

Childs();

I hope this does what you were looking for.

[Daniel Leu]

Here is the same code again but this time it uses the new javascript iterator map:

function Childs() {

  // get all child records
  var childs = record.getFieldValue('fld-c22501cc3910474aa1c59387fde30d82');

  // define id of name field of the child form
  let childNameId = 'fld-8b8f3b0cd59b4b4c9180a8903685e7ee';

  // get child names in a array
  let childNames = childs.map(function(i){ return i.getFieldValue(childNameId)});

  // return child names as a comma separated string.
  return childNames.join(', ');
}

Childs();

[Author]

Posts