Database search options

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.