Autocomplete with multiple value fields

[mymdsdigital]

Hi I am wondering how can I set multiple value fields for the auto complete component.

What I want to do is:

Once that the user has selected the autocomplete value, let’s say email, I would like to insert this info into a database, the problem is that I can only set one value (e.g. email). but I would like to add email, first name, last name and user id.

How can I do this?

Thanks

Juan

[Teodor]

Hello,
You can use the autocomplete value to filter a database query and insert the results.

[psweb]

All the "auto complete" has is a data source, be it database or API, then a "text" and a "value" so.

1. Have a database query to only look for the data to use for the Auto Complete which runs on page load possibly.
2. Have a second database query that queries the users database where the extra info is stored that has a condition of the value of the auto complete
   OR
   • Run a database insert/update with the condition set to the value of the Auto Complete chosen value.

To send the value from the auto complete to the server action use dynamic attributes on changed.
Here is a post I just answered with some of the stuff you will need.

Autocomplete value to array

Hi Otavio So it sounds like it should be pretty easy to do Add an empty “Array” to your page [Screenshot 2020-06-02 at 09.29.37] Add an “Auto Complete” component [Screenshot 2020-06-02 at 09.31.46] Select the “Auto Complete” component and enter your Data Source Text Field Value Field Add a “Dynamic Event” of “Data, Value Changed” and set the action to “Array, Add Unique Item” then choose a Value Property, which will be the value of the “Auto Complete” To see what is going on, add a bin…

[mymdsdigital]

Thanks guys, this works perfectly!!! I have been trying to make it work for the past 2 days
Regards
Juan