🚀 [Performance] Auto populate a field B from field A´s value in the database

[ryanck]

Hello,

I was wondering if it would be possible to have a realtime auto-populate of a field based on another field´s value. Let me explain:

I want to provide an auto-populate input based on the list of companies VAT ID. So for example, if a user enters in the input A a VAT ID that is on the companies database, I want the field B to be auto-populated with the company address.

I´ve tried it doing a “do a search for” but it takes a while so if the user hits the tab, then it won´t be auto-populated.

Does anyone know how to do this? Or if it´s possible?

Thanks a lot.

Have a nice day.

[ryanck]

I´ve seen there are some workarounds like putting a button or something like that but the good one it would be to have a real time auto populate.

[troy.roberge]

If you have a screenshot it might help us?

My thought would be doing the search early (maybe on page load). Then do a compare based on that?

It’s not perfect, but without more info, it’s the best I have.

Hope it helps.

[ryanck]

Hello @troy.roberge,

Thanks for your reply man.

I´m attaching a video and two screenshots so you can see. I have two inputs that are the same but one does a “do a search for” directly to the database and the other one does search via filter to a Repeating Group.

It has the same delay and the problem is when you use the TAB the field does not get auto populated.

Do a search for screenshot:

RG filter screenshot:

A video so you can see it:

Thanks a lot for your help.

Bests.

[ryanck]

Maybe option sets will be so much faster?

I´ve not tried those yet.

[ryanck]

Hello,

Can anyone relive this post? Is there anyway to get this working kind of instantaneously so when the user fills a field and it finds the field data into the database, automatically fill the other field?

It could be good for countries so when you put the postal code, automatically set the province/estate for example.

Thanks a lot.

[melon]

Use ZQ Fuzzy search

[ryanck]

Thanks for the suggestion but i don’t think that would work since it has to happen something like like you can see in the video of the post.

[Performance] Auto populate a field B from field A´s value in the database

Hello @troy.roberge, Thanks for your reply man. I´m attaching a video and two screenshots so you can see. I have two inputs that are the same but one does a “do a search for” directly to the database and the other one does search via filter to a Repeating Group. It has the same delay and the problem is when you use the TAB the field does not get auto populated. Do a search for screenshot: [doasearchfor] RG filter screenshot: [rgsearch] A video so you can see it: Thanks …