Hi,
I have my Airtable connected, running code by Zapier and Detrack account connected to my Zap. All works fine on a single line do_number. However, with a multi-line do_number, only one line uploads. The other lines do not because “Validation Failed: Field do_number is already taken”. The do_number is basically a order number. See screenshots below and any help is greatly appreciated.
Each step shows success…
This is by Zapier code
This is the halt
Best answer by calvinscm
To whoever this may help, I figured out how to make this work correctly. In Airtable, set the items fields (array requirements) to a rollup, use ARRAYUNIQUE(values) as the formula and voila, uploaded perfectly.
To whoever this may help, I figured out how to make this work correctly. In Airtable, set the items fields (array requirements) to a rollup, use ARRAYUNIQUE(values) as the formula and voila, uploaded perfectly.
+6Hi
Thank you for looping back to this post and sharing the solution here. This will be helpful to our Community members.
Happy Zapping! ⚡️
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
