First you have to link the two forms. In F01a, create a link to form field and give it a name (eg link). Then set the link type to join, select F04a as the form to link to and use the MatTar and TarRef fields for the values.
Next turn F01a.TarNam into a script field. Following field script should do the trick. I have added comments to describe what I’m doing:
function getTarCln() {
// get F014a form
let f04a_form = document.getFormNamed("F04a");
// get field id for TarCln
let tarCln__f04a_id = f04a_form.getFieldNamed("TarCln").getId();
// get field id for link field
let link_id = form.getFieldNamed("link").getId();
// get linked records
let f04a_recs = record.getFieldValue(link_id);
// check that there's only one record
if (f04a_recs.length > 1) {
console.log("Error, more than one record");
return;
}
// get value from F014a form
let value = f04a_recs[0].getFieldValue(tarCln__f04a_id);
console.log("Value fetched: " + value);
// done, return value
return value;
}
getTarCln();
This script assumes that the field that links the two forms together is called link. You can change this on line 10.
The return type of the script must match your field type, eg Number, Text, Date.
This is JavaScript and not Java. Although they share part of their name, they are totally different beasts.
.
