CODEWITHSUNDEEP
oracle-apex
greg
greg

Reputation: 85

Display one value and return another in text field with autocomplete Oracel Apex 5

I want to be able to have a text field with autocomplete in Apex 5 that displays a client name, city and state, but just returns that client's client_id from the table.

I'm currently using a popup LOV

Is something like this even possible? I've been digging around for hours for a way to make it happen.

Upvotes: 0

Views: 1411

Answers (1)

hisnameismyname2
hisnameismyname2

Reputation: 387

There are plugins out there that accomplish this, but I haven't personally used them.

Here's what I've done:

  1. Add a hidden item
  2. Create a dynamic action to parse the autocomplete item and set the hidden item equal to this value.
  3. Create a validation to ensure that the hidden item's value meets your expectations.

Upvotes: 1

Related Questions