1. What is the issue? Please be detailed.
Thank you so much for the work that has already gone into developing the entity based submissions. It is really helpful - a game changer.
I have been playing around with the Tree forms that Kathleen demonstrates in this video to try to understand how it works. Using these as the example I have created a tree entity using the tree_registration_form and then will enter multiple records of the tree measurements for that same tree using the follow-up form. In the follow-up form is pulls a measurement from when the entity was created as the reference. What I would like to do is to pull in the most recent measurements from the tree follow-up form and use that for reference and validation.
So I have set the tree_follow_up form to save to a separate csv called tree_measurements.csv.
What I can't work out is how to interrogate tree_measurements.csv to get the most recent submission for that tree. The two ways I can see is to either use the submission date/time, or to create a serial number for each tree's submission and pull the biggest serial number in as the last measurement. However, I can't quite make ir work. I think that I lack understanding of how to use this syntax
I attach the file of how far I reached
trees_follow_up_Previous.xlsx (80.3 KB)
This Tree Registration Form form is unchanged from Kahleen's demo
trees_registration_entities.xlsx (61.4 KB)