r/Quickbase • u/mickyburton • Mar 30 '21
How to avoid duplicates, but allow for different suppliers
I would like to know if there is a way to avoid duplicate invoice numbers being added to records, but allow a duplicate if it comes from a different supplier (different suppliers sometimes use the same dates, etc for their invoices). Can this be done?
3
Upvotes
2
u/leetheyellO Mar 30 '21
I often create a formula field to return a concatenation of the company id and the invoice number so I can make that field unique.
3
u/mutigers42 Mar 30 '21
I second this -
Create a text formula field:
[company field]&” “&[invoice ID]
Then make that text formula field unique / no duplicates.
1
u/mickyburton Mar 31 '21
Thank you I'll try that 👍