If you have. let’s say, a text box called ‘text1’, you can use $w.onReady function inside your dynamic page:
$w.onReady(function(){
wixData.query('Member').contains('name', $w('#input1').value)
.find()
.then(res => {
if (res.items.length > 0) {
const firstItem = res.items[0];
$w('#text1').text = firstItem.code;
}
});
});
Please note that this is a general skeleton code, you need to adjust it to your page.
Liran.