Use Case: Update parent record with percent value from child record with the most recent period date. I am getting stuck with how I can go about filtering the child records to narrow down to the child with the most recent period date. Not sure if I need to have a loop to iterate over all the child records related to the parent and filter it in the "for each" section of the loop or if I can just filter out the records when I use my GetRecords element with a formula? I think I can use a MAX() function on the date somehow.
2 个回答
you can set your Get Records to just store 1 record, and have it sort by the field you want (period date) so that the one you want is retrieved.
