Not necessarily, no. You could handle exporting a CSV for only the newest repeat/inspection entry a few different ways, but using the "Export Data" option in your item details page is going to export the who dataset at once.
If you ONLY want to show your most recent inspection in a CSV, here's some off-the-cuff ideas.
- Put a table in a word document to use as your feature report template and then filter the portion that prints out your repeat. (Something along the lines of only printing max(${$inspection | getValue: "position"} or ${if inspection_status='new'}${inspection}${/}. (I know the latter example would work in the feature report if that's way your workflow is set up. Not sure on the first example, but you could handle that in the form itself too). This process would make it so you can just copy the table out of the feature report and past into a CSV file. If you're not all that confident with any of the other recommended workflows, this is probably one of the easier ones to get working.
- Display your results in a dashboard and enable CSV export. (Layer 0 is your bird box/geolocation info and is displayed in a "list" element. Layer 1 is your inspection table and displayed in a "list" element. Selecting a bird box in the first list filters the inspection table in the 2nd list, which has the option to export directly to a CSV built into it. Filter to the most recent inspection by default, or let people flip a toggle switch to filter to the most recent inspection). This one is also fairly easy to set up once you have your feature layer published, but formatting the CSV a specific way can be a bit of a pain if you weren't thinking about that when you set it up.
- Use webhook automation (like microsoft flow or integromat) to auto-export a CSV on every survey submission. If you wanted, you could have it update a running tally spreadsheet each time, but also export a different CSV that only contains the most recent inspection. (I have a few surveys doing this now, exporting to a google sheets document that can be downloaded as a CSV)
- Connect to your feature layer in ArcGIS Pro and manually export selected records to a CSV as needed.
That's just a handful of ideas, but it'll depend on how you want it to be set up. Making each bird box a feature on layer 0 and each inspection a record on layer 1 will automatically build a "relationship" between the layers when you publish it. This can make working with the data -a lot- easier in many cases, but slightly more difficult in a few I suppose. I try to give myself both options by copying over some of the layer 0 data over to my repeats behind the scenes. For instance:
(integer)${birdBox_number}
(integer)${birdBox_size}
begin_repeat
(hidden, integer field type)${birdBox_number_copy} = ${birdBox_number}
(hidden, integer field type)${birdBox_size_copy} = ${birdBox_size}
end repeat
This way, I have the built-in relationship and can link dashboard actions with stuff like GlobalID & ParentGlobalID and restore backups easier, but I also have a simple, human-readable spreadsheet for layer 1 that I can use easily for simple tasks.