The desired functionality I am looking for is such:
User enters part of a last name into a text field on a form.
A search is performed to a master list of names using that text field.
If a match is found, several fields (last name, first name, email) are filled in based on the record that was matched.
I am trying to avoid having to user the drop-down/pop-up options through standard record picker lookup.
Any ideas? Can I possibly use Formula URL in some way?
I have a user table where the Keyfield is user and I update that field with the record ID that the user sitting on.
Then I present the user with a regular Quickbase report with all the filtering and dynamic filters which allows the user to make their selection. They hit a button on that report and it updates the original record they were sitting on appropriately and then redirects to wherever is next logically for the workflow.
It's a little too complicated to post the step-by-step cold here but feel free to contact me via the contact info in my profile for a further explanation.
- 847 Conversations
- 16 Followers
- 737 Conversations
- 5 Followers
- 3357 Conversations
- 150 Followers
- 3064 Conversations
- 84 Followers
- 2684 Conversations
- 52 Followers
- 226 Conversations
- 4 Followers
- 7350 Conversations
- 201 Followers
- 1130 Conversations
- 11 Followers