Skip to main content
Question

Duplicate check based on 6 form fields (includes date/currency/text)

  • May 19, 2021
  • 0 replies
  • 26 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You should be able to make a concatenated field.

List("-", 
ToText([a date field]),
ToText([a numeric field]),
[text field 1],
[text field 2],
[text field 3],
[text field 4])




------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------