How to input all values from a Fetch Record and return to a Multi Line field
Hello Everyone,
I'm having an issue I can't understand.
This formula is working. The info statement shows me that all the proper records were retrieved and can be returned.
for each r in Workout_Tracking[Single_Exercise_field == varSW]
{
input.test_report_text = r.Date_Time_field.edate(0) + " - " + r.Reps_column + " reps";
info r.Date_Time_field.edate(0) + " - " + r.Reps_column + " reps";
}
However, when inputting that Fetch Record list into the Multi Line field 'test_report_text', the only value that is inputted is the latest value from the Fetched Record list. I want to have the entire list inputted into the Multi Line field.
What am I missing in either my formula or perhaps some knowledge about multi line fields I wasn't aware?
Thanks for the help!
Michael