zoho forms with data validation

zoho forms with data validation

hey,
i want to use zoho forms as a "code redemption" - element. I have a google sheets with valid codes. Users should be able to type in a code into the form. Form should check if the code is in the sheet. If yes --> positive message, if not ---> error message. The confirmation / error message should ideally show up without reload. Alternatively after form submission. Any idea how to solve that? Or maybe zoho forms is not the right tool?

thanks al lot!!