Hi, I have created a stateless form from a master form.
My master form contains the following fields:
- Unit No.
- Lease End Date
- Checklist Item 1
- Checklist Item 2
- Checklist Item 3
I have created a stateless form that fetches data from the master list based on Unit No.
Throughout the year, I may have the same Unit No. that has 2 lease end dates (say 6 months apart).
I worked out that I can sort column by descending Lease End Date & the stateless form will pull up the most recent data. The Deluge script entered in the "On User Input" for the Unit No. is as
follows:
RecData = Master[Unit_Number == input.Unit_Number] sort by Lease_End_Date desc;
Lease_End_Date=RecData.Lease_End_Date;
Checklist_Item_1=RecData.Checklist_Item_1;
Checklist_Item_2=RecData.Checklist_Item_2;
Checklist_Item_3=RecData.Checklist_Item_3;
However, I would like to be able to fetch data for the earlier lease expiry date in the stateless form, but I can't work out how to do this. I note there is a "
contains more than one record
(return fields values as list)
" but it doesn't seem to affect my stateless form. If I don't
sort by the
descending
Lease End Date column, data associated with the first entry is returned in the stateless form instead (not the most recent data). Is it possible to have a list appear in the
Lease End Date field so I can select the correct date & hence record that I am trying to
retrieve?
Can someone please assist with my query? Thank you in advance.