Dynamic Searches - Display First & Last Name while searching on Last

Hoping someone can help me…

I’ve created a Search Field. It’s linked to a Data Type of People with Elements of First and Last Name. I have the SearchBox set to Dynamic and set to search for Last Names and Sort by First. But is there a way to Display the First and Last name to select the appropriate person?

I get this:

image

Thanks
Andrew

Hmm :thinking:

Good question. If I understand you correctly, maybe this could work.

When saving the users name, on the backend also create data field called fullName. Then you can search that field.

Would that work for you?

@j805 www.NoCodeMinute.com

Hope that helps! :blush:

By the way, welcome to the Bubble community! :raised_hands:

2 Likes

Hey @J805,

Thanks for the welcome. I’m quite excited to learn how to use Bubble to it’s full potential. As a software designer and engineer, I’m thrilled about Bubble because I can focus on design and not the nitty gritty in code. But it can also be frustrating when you know what you want to do, but can’t quite figure how to do it within the boundaries of Bubble. :slight_smile:

In regards to your suggestion… The fullName field could work if the search will search using “contains”. So far the search is using a “Starts with”. Do you know where/if I can change that?

For the FullName to be a computed entry in the database, I just set that during submit right?

fullname = Input First Name’s Value:append :append Input Last Name’s Value

Hmm… can I set it in the actual definition of the field vs. saving the data to the table? I wonder if this will bloat the database.

Thanks again for your help. I really appreciate it.
Andrew

PS: if these questions are something I could have got from a manual or other source, let me know… I certainly don’t want to waste anyone’s time and I am very capable of RTM (reading the manual) :grin:

1 Like

If you really want more flexibility in a search I normally use the Search & Autocorrect plugin and then create a repeating group to display my data. It is much more flexible. Then you will have all those options you want. I hope that helps! :blush:

Searching the Forum is sometimes the best resource. If you don’t find your answer when searching the forum then you are more than welcome to create a post. It’s fine, we are happy to help when we can. :+1:

Other options for research:

Bubble Manual

Bubble Full Reference

Thanks, again.
I really appreciate your help. I’ll check out that plugin.

BTW: Looks like the search does do a lookup on either first or last name… but you have to start the search with the start of a word. So “Andr” would bring up Andrew and Andrea… but “ndre” won’t bring up either. Same on last names… the start is what it goes by.

1 Like

Cool! Glad it started working. :+1: