
I have a cognito form with repeating sections for each "opportunity" that I have adding rows to an excel table for each opportunity. When the form entry is updated, I need to look at all the rows and if the opportunity matches an existing row based on a specific column then the row should be updated. If there is not a row that matches the opportunity field, I want to add a row.
I have a filter array set up to see if the fields match but it's adding the rows that already exist and duplicating the rows in excel multiple times.
Any help is much appreciated