I’d double check that you’re mapping a new ID when you do the add(array;value) formula and not one that is already in the original array. I just did the same set up and it worked as expected.
Okay, so I am wrong. Just using a list might be in Airtable’s own automations. I swear I’ve done it like that before. But regardless, you don’t need the array aggregators, just use add array function.
add ( array ; value 1 ; value 2 ; … ) (https://ww...
Have you tried listing all the linked records separated by commas? It’s been awhile, but I recall not needing to turn it into an array for adding multiple linked records.
The new column is trying to show the pass date based on whether it was Quiz 1 or Quiz 2? Is there a column that says whether Quiz 1 or Quiz 2 is passed? You could run the formula off of that instead. Here’s a formula if it’s a checkbox field. It will...
Make should work as Kamille_Parks mentioned, but if you don’t want to use Make because you’re already familiar with Zapier. You could create a new table for the Zap to send payment records to, and then work within Airtable’s automations to connect to...