Forum Discussion

AmyGosz2's avatar
AmyGosz2
Qrew Cadet
7 years ago

Creating an Automation so only 1 deposit record is created for multiple checks

I have a table called Checks (parent) and another table called Deposits (child). When a check is entered, the automation creates a Deposit record for that bank account and that date. However, if I ...
Formulas and functions
Quickbase Automations
AmyGosz2's avatar
AmyGosz2
Qrew Cadet
7 years ago

I did not have that set. I did set that now in the TRIGGER Criteria section so will see what happens next time entries are made. It's always the little things that one misses..... Thank you for the quick response!
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Right,
So the issue is that you only want to create that record (One Bank Account on one Date) where it does not yet exists. 

When you try to create it twice for the same value, that field is the Key field to the table and hence it is not allowed to be there twice.  So that is why the Automation was unhappy.