Display linked content

Hi Vera,

There are a couple of problems with your script.

First off, you haven’t defined link_invoice anywhere, yet you’re referencing it.

Also, you haven’t defined index, yet you’re using it as an array reference.

Take a look at the Child Records Loop snippet. If you select your invoice number field from your Linked form on the Fields list on the left, then double-click on the Child Records Loop snippet at the bottom-left of the Script Editor, Tap Forms will write a function for you to loop through all of the records in your link_invoice Link to Form field.

Since it’s a many-to-many, there can be multiple values for Invoice Number.

But if all you want is the first one, then you could do:

function get_invoice_number() {
   var invoice_number = '';
   var link_invoices_id = 'fld-.....';
   var link_invoices = record.getFieldValue(link_invoices_id);
   if (link_invoices.length > 0) {
      var first_invoice = link_invoices[0];
      var invoice_number_id = 'fld.....';
      invoice_number = first_invoice.getFieldValue(invoice_number_id);
   }
   return invoice_number;
}

get_invoice_number();

You of course have to replace ‘fld….’ with your own field IDs, which you can get from the Fields list on the left.

Hi Vera,

Ok, so your script is good, except the only thing you’re not doing is returning your invoice number value.

Where you’ve said record.getFieldValue(invoice_number_id), you could just prefix that with return. As in return record.getFieldValue(invoice_number_id);.

But better would be to just return the first invoice number from the first record in the array.

To do that, use this code after the var link_invoice line (line 5).

if (link_invoice.length > 0) {
    var first_invoice_record = link_invoice[0];
    return first_invoice_record = first_invoice_record.getFieldValue(invoice_number_id);
}

The above code just checks to see if there is at least one link_invoice record. If so, it then gets the first link_invoice record from the list of linked records. Then it gets the value from the invoice_number field.

And that’s it!

Hope that works for you.

Thanks!

Brendan