Ingnore Reporting Error 400 on add new record
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 Ke...
Forum Discussion
I suggest that you put a condition on the Action so it does not try to duplicate a Key field. I'm not quite sure I understand your setup in terms of duplicating the Key field, but it sounds like you have a 1 for 1 relationship where every parent has exactly 1 child record and you have set the Key field of the Child to be the same as the Record ID# of the Parent.
If that is the case, then you should be able to do a summary field of the # of children, and not fire the Action of the Parent already has it's child record created.
If that is the case, then you should be able to do a summary field of the # of children, and not fire the Action of the Parent already has it's child record created.
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
