How to log user in without a password

Need help Database
1

i am using an otp based login system

i can search for user email from db using their number but i can;t find a work around for the password field

how can i allow the user to login using the otp instead of email and password

2

magic link

3

You can use a magic link or assign a temporary password to the user. You can also build a OTP code system in a bubble as well.