PeterKrasznekew
4 years agoQrew Trainee
Duplicate check based on 6 form fields (includes date/currency/text)
Hi all,
We are trying to set up a duplicate check when entering a new record via a form, however, that check needs to be based off of 6 different fields - 1 date, 1 currency, 4 text. I was originally intending on making a formula-text field to display all that information as a string and then set that field to unique, however, with the different types (date, text, currency) that does not seem like an option. Is there another option to setting up this unique value field?
Thanks in advance.
------------------------------
Peter Krasznekewicz
------------------------------
We are trying to set up a duplicate check when entering a new record via a form, however, that check needs to be based off of 6 different fields - 1 date, 1 currency, 4 text. I was originally intending on making a formula-text field to display all that information as a string and then set that field to unique, however, with the different types (date, text, currency) that does not seem like an option. Is there another option to setting up this unique value field?
Thanks in advance.
------------------------------
Peter Krasznekewicz
------------------------------