I am using Quick Base Actions to add a new record to a child table when a new record is added to the parent. The parent table is connected to a Drop Box CSV file and the field I am copying is the Key field in the Child Table. The copy is working fine, but when I rerun the Connected table Sync to update the parent table the Action is triggered. When the action try's to add a new record to the Child table it raises the 400 error "cant add duplicate record to Key field".
My question is can the 400 error be ignored and not be reported as a failure. I am still in the testing faze but production will have over 10,000 records that is a lot on error messages
Sounds like we are on the right track I tested the solution but still got the error.
below is the criteria I added
this is a one to one as you stated The parent is a read only Synced table with 28 fields and the Child has additional fields that needed to be added to the work order table and needed to be editable by the user
Here is the screen shot of the error
Thanks for you help