Here is my error message:

In my automation, I have multiple linked columns in one table being entered into one linked column in the second base. Now these multiple columns are each a name in a record, “name 1”, “name 2”… etc. Often a record only has a few names (it could have 1 out of 5).

My automation succeeds only when 4/5 or 5/5 names are full, when there are only 1, 2 or 3 names in the record it fails.

Does anyone know why this is? To me it would make more sense for it to fail 5 out of 5 times but it only fails when there is less than 4 names…