I think I'm missing something basic, but hope people can help even if I'm not.
I created a S123 form that has repeats. I use it to sample the same fish every month, and each sampling is a "record" with 100 fish and their various measurements (e.g., fork length, weight, appearance). I would like to generate a report that collects a particular measurement type (e.g., fork length aka FL) over the course of the records so I can track changes in growth. Each fish has a unique identifier that is scanned each time (a PIT tag), even though they may not be sampled in the same order each time (and it's actually highly unlikely they would be or I should buy a few lottery tickets).
My report would (hopefully) look like this:
| PIT tag | Sampling 1 | Sampling 2 | Sampling 3 | Sampling 4 | Sampling 5 | Sampling 6 |
| Fish1 | FL at Sampling1 | FL at Sampling2 | FL at Sampling3 | FL at Sampling4 | FL at Sampling5 | FL at Sampling6 |
| Fish2 | FL at Sampling1 | FL at Sampling2 | FL at Sampling3 | FL at Sampling4 | FL at Sampling5 | FL at Sampling6 |
I have tried using the repeat name ${#Individual_Records} in the same cell at where Fish1 would populate, but maybe I need to have the report looking at the overall data table (which lists all samplings)? Is there a way to do that and then put something like ${if Sampling Date = '8/15/22 8:56' | ${FL}}? (My sampling dates are text questions in my XLS form, and use a calculation to pull "Now" and format it... I think that means I shouldn't have to do anything due to UTC.)
I really feel like I'm missing something simple, but can't figure it out... attached are my form and a screenshot of my data table in S123
Thank you!
Lea
