Forum Discussion
AlexCertificati
6 years agoQrew Cadet
The problem is automation results in errors 80% of times: "Trying to add a non-unique value to a field marked unique".
I guess this happens because at the point the scope for automation's actions is defined, the field "DestinationExists?" is still "False".
I think you might be overthinking this? Sounds like in the table where you're adding records, you have a field that's set to accept only unique values, but your automation is attempting to add records that have non-unique (blank?) values in that field. Is that a direction you looked when troubleshooting your issue here?
- AlexanderBerezo6 years agoQrew MemberChecked the table now and there are just two fields marked as "unique": Destination ID (Key field) and Record ID# which I cannot unmark as "unique".
- QuickBaseCoachD6 years agoQrew CaptainI wish there was a native answer to this. The issue is, as you state that the records are being added in batches, and you want to trigger the Add record in the other table for just the first new unique value.