See the most recent attempt below. Basically I've found lots of info on fetching data but not too clear on how to then put it into form fields when you're fetching a range.
I would like my users to be able to see the three previous entries into this form (Daily_Nursery_Log), when they are adding a record in this stateless form(Nursery_Action_Log).
I thought it would be easier to input the key fields as one single line field combined, as you can see below. But that is not a requirment.
I've tried a ton of things based on zoho how -to pages. What's the best way to do this? I cannot create a subform because this is a stateless form.
----
Rec=list(Record_1,Record_2,Record_3);
y = Daily_Nursery_Log[ID == input.Accession_Number] sort by Action_Date desc range from 1 to 3;
For each x in y
input.Rec= x.Nursery_Name + "-" + x.Action_Date + "-" + x.Action_field + "- Qty :" + x.Number_Containers + "Size :" + x.Container_Size + "Bench :" + x.Bench_Location;