Search related fields for Duplicate

Question

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

blakeharrison · Answer

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

michaeltamoush · Answer

That's a brilliant idea. Going to do that right now.------------------------------Mike Tamoush------------------------------

Forum Discussion

Search related fields for Duplicate