I'm working on a tracking system for a coral restoration project. To report coral bleaching to my Bleaching Report table, a user selects a date and all structures where bleaching was observed (linked to my Structures table) like so:
Bleaching Report table:
I would like to add a new record for each structure along with the corresponding date to a different table, like so:
Structure Bleaching table:
I tried setting up an automation which triggers when a new record is created in Bleaching Report to create a new record in Structure Bleaching for every linked item in the Structures field, but it seems only 1 record is being created even when there are multiple structures linked in the field. Here is my automation setup:
The "ID" is selected from the Current item. In the test data for "Repeat for each in Structures", the Input List is returning all the correct structures so I can't figure out why it doesn't iterate over all of them. The record that gets added is correct, but it seems to only add a record for the first structure in the list. If anyone has any insight that would be greatly appreciated! I'm also open to doing this another way in case there might be a better solution