Forum Discussion

PeterKrasznekew's avatar
PeterKrasznekew
Qrew Trainee
4 years ago

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
------------------------------

1 Reply

  • 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
    ------------------------------