Discussions

Expand all | Collapse all

Search related fields for Duplicate

  • 1.  Search related fields for Duplicate

    Posted 9 days ago
    Edited by Mike Tamoush 9 days ago
    I have a related field that has a dropdown where you can search as typical (probably 30,000 records) for a particularly entry number (number is really an alpha numeric code). If the record the user wants does not exist, I have a text field that says 'Enter New Entry Number'.

    However, if they manually enter a new entry number that already exists (perhaps they didn't search correctly or even try to search), I want the system to not allow it.

    I eventually use one of their two choices in an automation. So alternately, is there a way in an automation to say "If exists, do x y z. If does not exist, add record, then do x y z"

    Is this possible?

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Search related fields for Duplicate

    Posted 9 days ago
    Is the Entry Number the key field for the related table? If so, you can build another relationship (exactly like you already have), but then change the new 'Related Entry Number' field to a formula field that references the 'Enter New Entry Number' field. You'd want to have some lookup value for this new relationship - probably Record ID# - and then you can set a form rule to 'Abort Save' if there is something in the entry field and there is no value in the lookup field.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------



  • 3.  RE: Search related fields for Duplicate

    Posted 9 days ago
    That's a brilliant idea. Going to do that right now.

    ------------------------------
    Mike Tamoush
    ------------------------------