Forum Discussion

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

Qrew Cadet

7 years ago

I think I got this working, but I always get an error message email when multiple entries are made for the same bank account/date.

Message: "Trying to add a non-unique value to a field marked unique, The field named "Bank Account-Date 2" with field id 154 requires a unique value."

Is there something I may have forgotten to mark, or maybe didn't do this quite correctly?

Forum Discussion

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

Related Content

Using Grid Edit to Edit Multiple Records at Once

Create multiple records on one form

Edit Multiple Records at Once with Grid Edit

AI Smart Builder for Creating Apps and Streamlining Pipelines

Combining Multiple Text Lists into One Text list Field