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

You can create a table where the Key field is
Bank Account-Date and also make a formula check box field on that table called [Bank Account-Date exists?].  The formula for that field should be 

true 

so it will always be checked.


Then make a relationships back to your Checks table based on the formula field [Bank Account-Date] and look up the 
[Bank Account-Date exists?] field.

Then set the Automation to only fire when the [Bank Account-Date exists?] is unchecked].