![](https://static.wixstatic.com/media/a27d24_ad91dbdee6f746909e37ee4bdd245ea3~mv2.png/v1/fill/w_746,h_267,al_c,q_85,enc_auto/a27d24_ad91dbdee6f746909e37ee4bdd245ea3~mv2.png)
Here is my database.
![](https://static.wixstatic.com/media/a27d24_fb8e35a95a0c4db39449d97ed4aa143f~mv2.png/v1/fill/w_629,h_231,al_c,q_85,enc_auto/a27d24_fb8e35a95a0c4db39449d97ed4aa143f~mv2.png)
Here is my page. The "Enter your email" is called "input1", and the "Show Amount" is called "input2".
My question is is that possible when my member enter they email at "input1" then "input2" will automatically show the correct number?
How to retrieve data from database when the email is match?
Thank you sir! The code is work. But the "input2" is still empty.
I try to change the database field type from number to text and change the code
$w('#input2').value = Item
From .value to .text
But the "input2" is still empty.
When i preview i can see the code working it does have found the record but cannot display at "input2"
I try the code as below but it didn't work.
wixData.query("Wallet") .eq("email", ) .find() .then((results) => { console.log(results); if (results.items.length > 0) { let Item = results.items[0]; console.log(Item); $w('#input2').value = Item } })
The "input2" is empty didn't show any thing.
Just use Wix Data Query with the eq function to get the matching email etc and get the users amount from the appropriate field of your dataset.
Anyone help me?