Autofill Form Help

docflash · 2020-06-07T18:27:18.568Z

I have searched the forum and haven’t been able to find a straighforward solution to my problem.

I am building a business application and need a form that will retrieve the personal information of existing clients and autopopulate all of the data into the appropriate fields: Last Name, First Name, Street, City, etc.

I see where the search box can be used, but it only allows filtering by a single field. So if I search for the client’s name and there is more than one person with that last name I can’t select the desired client. It does give me a choice, but no first name is listed. Furthermore, If I select the one that says, “Smith (1)” then the last name is filled with the name followed by (1). (see screenshots)

This is a very common need in business forms, so I’m guessing somebody has figured out and easy way to do this.

Anybody?

Capture 12736×1824 297 KB

Capture 22736×1824 301 KB

ambroisedlg · 2020-06-07T18:41:59.202Z

hey @docflash

You could make it work by creating a custom search, using an input field, a focus group and a RG (the RG would display Clients inside the focus group)

docflash · 2020-06-07T19:47:45.848Z

Thanks for the reply. Could you give me a brief example? And would I be able to select the choice in the RG and have it auto-populate all the fields. I built the one in the YouTube video, " Building an Auto-Complete Search Feature on Bubble.is" by Coaching No Code Apps, but it doesn’t allow you to select anything in the RG.

Thanks.

ambroisedlg · 2020-06-07T20:01:29.930Z

docflash:

I built the one in the YouTube video, " Building an Auto-Complete Search Feature on Bubble.is" by Coaching No Code Apps, but it doesn’t allow you to select anything in the RG.

That’s the one you want. What it does when a cell in the RG is clicked is up to the workflows you build along with it. You might need a custom state on the page as well.

Build a workflow like when Group (cell) is clicked → set state to Current cell’s User’s unique_id
Assuming your form is of type User, put a conditional on the form group to Search for User constrained with unique_id = page’s state
The fields’ values could then be Parent group User’s field (first name, last name…)