[Solved] Get value of lookup field within a subform

[Solved] Get value of lookup field within a subform

Hi,

I am using sendmail to receive a copy of submitted form values, and i've run into output such as this:  2511901000000056650

I found success with support's help by utilizing this syntax:

  1. get_customer = Customers_Form[ID == input.Customer_Name].Customers_Database;
But now I need that to work for 3 fields in a SubForm, 2 of which are lookup fields.

This is what i have, but it's not quite right. I also don't want it to pull ALL the records, but ONLY the ones submitted in the subform.

  1. subformContent="";
  2. for each line in SubForm
  3. {
  4. subformContent=subformContent + line.Qty + " x " + line.Containers + " of " + line.Products + "<br>";
  5. }

Which outputted:

5 x 2511901000000056578 of 2511901000000056650
66 x 2511901000000056522 of 2511901000000056726
5 x 2511901000000056546 of 2511901000000056626
6 x 2511901000000056578 of 2511901000000056726
5 x 2511901000000056518 of 2511901000000056730
7 x 2511901000000056554 of 2511901000000056730

even though i only inputted rows in the subform. Any suggestions?