AnsweredAssumed Answered

Script calculation Email

Question asked by acro on Oct 31, 2018
Latest reply on Oct 31, 2018 by acro

Good afternoon, working on a small data base and I have just extracted the necessary elements to illustrate the question I need help with. In this sample we have two records and each record represents one customer.

Each customer has related records from a table named Open invoices, so each customer has their own set of invoices (see pictures 1 and 2).

I created a button that will trigger a script to send an email to reference all the selected customer's invoice numbers in the subject field of that email. I cannot figure out the syntax needed to specify a calculation that will reference all invoice numbers from the related open invoices table in the email subject field. Any help will be very appreciated!!

 

Untitled-1 copy.jpg

Untitled-2 copy.jpg

Untitled-3 copy.jpg

Untitled-4 copy.jpgUntitled-5 copy.jpg

Outcomes